Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Acumulated value using measures for YTD

Hi Everyone,   I'm having problems with the acumulated value coming from measures.    As you can see in the picture, the last comumn (YTD) should be : 13,06 (13,06 from first month) 25,57...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try like

     

    YTD Sales = CALCULATE(SUMX(values('Date'[Month Year]),[Avg Net Price]),DATESYTD('Date'[Date],"12/31"))

     

    To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try like

 

YTD Sales = CALCULATE(SUMX(values('Date'[Month Year]),[Avg Net Price]),DATESYTD('Date'[Date],"12/31"))

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hiiii many thanks for your help, I cant believe it worked  omg.

 

Could you explain that measure? why it works? why mine didnt.

 

Anyways thank you a lot 🙂