Tag: SUMMARIZE function DAX

Optimize Power BI Formulas Using Advanced DAX

I’ll go over some interesting concepts that involve using several table functions to optimize your Power BI formulas. I’m going to use an example from the Enterprise DNA Support Forum where one of the members asked if it’s possible to add a filter while using the SUMMARIZE function. This is quite common for scenarios when

Continue reading

Data Normalization in Power BI for Different Days Results

Normalizing Results On Different Days - Time Related Analysis In Power BI Using DAX

This tutorial stems from another question on the Enterprise DNA Forum about data normalization. The techniques that I will teach you will be important in getting rid of anomalies that can possibly make things complicated during the data analysis. Occasionally, when running analysis in Power BI, you may need to take into account the sales

Continue reading