Forum Discussion
TOTALYTD until a specific date
Hi everyone, Maybe the TotalYTD is not the good function for my purpose but I don't find my answer :-(. Can someone could help me please? 3 tables: RevenueLines (G_L) ; Calendar and Clos...
amitchandak
Super User
Super UserAnonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
If you need YTD based on today, not based on selection, you can try a measure like
YTD=
var _min = date(year(today()),1,1)
var _day = today()
return
CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date] >=_min && 'Date'[Date] <= _day) )