Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

2 Measures on same line graph

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

Custom Filter
custom formula
Line chart
line graph
Measures
related
Related Tables

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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.