Forum Discussion

ngocnguyen94's avatar
ngocnguyen94
New Member
3 years ago

Problems when calculating Cumulative value by DATESYTD

Hi, I just started to learn PBI and I got some problems when calculating cumulative with DATESYTD, hope sb can help plz. I got the Actuals data (from Jan-2020 to July-2020), main fields are Date co...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi ngocnguyen94 function DATESYTD is one of the time intelligence functions in DAX. The best usage of this / these function/s is to be used on Calendar / Date table as other usage is hard to explain. In your example use just Measure 2 for YTD amounts as best practice. Hope this help