How to calculate last 3 months sales with Dax in power bi?
To calculate last 3 months sales in Power BI using DAX (Data Analysis Expressions), you can follow these steps: Last 3 Month Sales = CALCULATE(SUM(SalesTable[Sales]), DATESINPERIOD(‘SalesTable'[Date], LASTDATE(‘SalesTable'[Date]), -3, MONTH)) This formula uses the CALCULATE function to calculate the sum of sales for the specified period. The DATESINPERIOD function is used to define the period, starting … Read more