Excel – XLOOKUP with fuzzy match

Recently, Microsoft has lunched the new Excel function XLOOKUP. Even if it is still in the Insider program, this function is becoming the most famous functions in Excel. Many articles are writing about this function so in this blog I will only talk about the match mode option. This function has the following syntax that … Lire la suite Excel – XLOOKUP with fuzzy match

Publicités

Power BI / Power Query – import table with total line (big mistake!)

Hello Everyone. Last week, I was working on a table of a worksheet used in one of my Power BI report, I added a total line to it then on my PBI report I refreshed the data related to this table. After checking the data, I noticed that the total line was added as a … Lire la suite Power BI / Power Query – import table with total line (big mistake!)

Power BI – Performance analyzer pane to export all data of a visual

Many Power BI users ask often about how to export the data of a visual especially when it exceeds the limit. As you know, Power BI Desktop let you export the data of a visual by clicking in the “…” then “Export data” to a .CSV file. Unfortunately and according to Microsoft documentation, there is … Lire la suite Power BI – Performance analyzer pane to export all data of a visual

Algeria Modern Excel and Power BI UG 2nd Meetup – Web scraping resources

During the demonstration On the 4th may 2019, I have participated to the second Meetup of the Algeria modern Excel and Power BI UG which was held in the IB-Solutions headquarter. During this meetup I had the honor to make a demonstration on how to make web scraping by using Power BI and R. In … Lire la suite Algeria Modern Excel and Power BI UG 2nd Meetup – Web scraping resources

R/Power BI – Principal Component Analysis on Algerian insurance market

On the following tutorial, you will learn how to use PCA to extract data with many variables and create visualizations to display that data on Power BI. In a previous blog, we have seen how to extract the Algerian insurance market data from internet by using the PDF connector of Power BI and in another … Lire la suite R/Power BI – Principal Component Analysis on Algerian insurance market