Default filter with calculate

[Diego_Vialle]

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?

[Anonymous]

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 · Accepted solution]

@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