Forum Discussion

Diego_Vialle's avatar
Diego_Vialle
Icon for Helper II rankHelper II
4 years ago
Solved

Default 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?    
CALCULATE
Date
FILTERS DAX KEEPFILTERS
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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