Forum Discussion
Anonymous
6 years agoNot applicable
YTD difference between 2 dates
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
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]))
1 Reply
- amitchandakSuper User
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]))