TOTALYTD until a specific date

[Anonymous]

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 Closing and the link between them in color.

3 measures : the first-two are OK but not the third.

Thanks for your help

[v-jayw-msft]

Hi @Anonymous ,

What the [70] is in the measure2?

Best Regards,

Jay

[Anonymous]

[amitchandak]

@Anonymous , 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) )

[Anonymous]

The very last part doesn't work 😞 @amitchandak 

[Anonymous]

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

[Anonymous]

@amitchandak I need to replace the "today var" by the closing date coming from the table "closing". But I can't manage it