Forum Discussion

WimBi's avatar
WimBi
Frequent Visitor
4 years ago
Solved

Performance DAX measure

Hi!   I have a question about how i can increase the time my measure takes to calculate. This measure calculates the difference of the revenue ("Omzet" in Dutch) of this year with last year....
DAX Calculation
  • PurpleGate's avatar
    PurpleGate
    4 years ago

    I have used this measure in the past to calculate what you want. It works really fast with many rows.

     

    YearOnYear = ((TOTALYTD([Revenue],'Date'[Date]))-(TOTALYTD([Revenue],SAMEPERIODLASTYEAR('Date'[Date]))))

     

v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi WimBi ,

 

Has your problem solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.