YTD difference between 2 dates

Anonymous — Wed, 15 Jul 2020 08:27:28 GMT

Dear All

I'm just trying to create a line chart by week that shows a punctual difference between 2 dates and the related YTD.

For the punctual calculation we succeed using also an holiday calendar. Here below the Dax

Ricevimento odv - inserimento CO = VAR Ricevimento = MAX('2019'[Data ricevimento odv]) VAR Inserimento = MAX('2019'[Data documento]) RETURN CALCULATE(SUM('CALENDAR'[is work day]), FILTER(ALL('CALENDAR'[Solar Date]), 'CALENDAR'[Solar Date] >= Ricevimento && 'CALENDAR'[Solar Date] <=Inserimento))

The problem is that the cumulated is not working:

Ricevimento Odv - invio CO cumulated = calculate([Ricevimento odv - invio CO],filter(ALLSELECTED('Calendar'),'CALENDAR'[Solar Date]<=MAX('2019'[Data ricevimento odv])))

Here below the relationship between tables and the graph that is not working (the red line)

Any idea?!

Thanks a lot for your help!!!!

Zeno

Re: YTD difference between 2 dates

amitchandak — Wed, 15 Jul 2020 08:59:26 GMT

Anonymous , have tried using use relation with datesytd

like this example

YTD 1 = CALCULATE(SUM('CALENDAR'[is work day]),DATESYTD('Date'[Date],"12/31"),USERELATIONSHIP('Table'[Date1];CALENDAR[Date])) YTD 2 = CALCULATE(SUM('CALENDAR'[is work day]),DATESYTD('Date'[Date],"12/31"),USERELATIONSHIP('Table'[Date2];CALENDAR[Date]))

topic YTD difference between 2 dates in DAX Commands and Tips

YTD difference between 2 dates

Re: YTD difference between 2 dates