2 Measures on same line graph

[Anonymous]

I have 2 rolling 14 day average calculations and Im hoping to display them (highlighted) on the same line graph:

However I've tried to create a date bridge and another table to relate to and still no luck with either approach.

Where it should look more like this:

Can anyone help with this?

SEE FILE ATTACHED

https://www.dropbox.com/s/ksi9fm0kbzpj1hg/Notification%20vs.%20Epi.pbix?dl=0

[amitchandak]

@Anonymous ,

Create a date table, Join both dates with that. (If they are from same table), one join will be inactive , you can activate that using userelation

rolling 14 will similar to

Rolling 14 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-14,Day))

In case you need to use userelation -https://www.youtube.com/watch?v=e6Y-l_JtCq4

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.