Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@Niiru1 ,
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.
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |