Difference between DAX and Excel functions that looks the same
If you know Excel functions, it is easier for you in Power BI with DAX. Sometimes it is mentioned as an advantage. It…
Convert TRUE and FALSE into 1 and 0 in Power BI
Here is a simple way how to convert TRUE and FALSE into 1 and 0 in Power BI. Precisely speaking – Power Query…
How to identify outliers in Microsoft Power BI
One of the simplest methods that you can detect outliers in Power BI is visual detection and IQR method that is also used…
How to generate date and time interval list with DAX
Here is how to create a new table and generate a dynamic date and time interval list with DAX. In this example, I…
How to calculate today’s date in Excel, VBA code in Excel, DAX, Power Query, R, PowerShell, CMD and SQL
No matter what kind of tool you use need to get today’s date remains. Here is how to do that in eight different…