Forum Discussion
Helper IIDefault filter with calculate
Is there any function that makes a filter to compare the current month with the previous month, and in the first column the same month but of the previous year?
Diego_Vialle , you need to create meausres uisng time intellgnence
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))to have xomplex display check calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
2 Replies
HI Diego_Vialle,
You can add an if statement to check if the current row context is the first one then replace the current calculation to calculate field values with the same month previous year filters.
IF function (DAX) - DAX | Microsoft Docs
Row Context and Filter Context in DAX - SQLBI
If you are confused about these, can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
- amitchandak
Super User
Diego_Vialle , you need to create meausres uisng time intellgnence
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))to have xomplex display check calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
