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) )
Hi,
No. My problem is about summing all the amount of account "70" from the first day of the year until the closing date which came from an other table.
This is the yellow part of my screen capture.
Thanks
amitchandak I need to replace the "today var" by the closing date coming from the table "closing". But I can't manage it