Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

  • 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]))