Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Niiru1
Helper V
Helper V

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.

Notification vs. Epi3.PNG

 

Where it should look more like this:

Notification vs. Epi4.PNG

 

Can anyone help with this?

 

SEE FILE ATTACHED

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

1 REPLY 1
amitchandak
Super User
Super User

@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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors