Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

sameperiode last year

Hi,   I want to compare data with the results in the same periode last year and have the next DAX formula: Total Calls = COUNT(NLE_PowerBI_verzoeken[HID]) Total Calls LY = CALCULATE( [Total Call...
Need Help
  • austinsense's avatar
    austinsense
    9 years ago

    The easiest way I've found to deal with this is to just check for a current value ...

     

    Total Calls LY = IF( [Total Calls], 
     CALCULATE( [Total Calls] ; SAMEPERIODLASTYEAR( Datum[Date])),
     BLANK())

    You actually don't need the third argument - BLANK() - because BLANK() is the default third argument for the IF() formula.

austinsense's avatar
austinsense
Impactful Individual
9 years ago

The easiest way I've found to deal with this is to just check for a current value ...

 

Total Calls LY = IF( [Total Calls], 
     CALCULATE( [Total Calls] ; SAMEPERIODLASTYEAR( Datum[Date])),
     BLANK())

You actually don't need the third argument - BLANK() - because BLANK() is the default third argument for the IF() formula.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks a lot for the solution. It works fine