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
sebasjun
Helper I
Helper I

Time Intelligence - Comparing Day of Week of Previous Month

Hello

 

I need to compare my sales this month eit previous motnh, but in the comparaison i need the same day of the week. Because now Im comparing a sunday (the office is closed) with a wednesday 

 

p1.png

 

Now my Meausure BookingLines PM (Previous Month) is

 

Booking Lines PM = CALCULATE(sum(Data[Booking Lines]);DATEADD('Calendar'[Day];-1;MONTH))

 

Calendar is my Master Date Table

 

Have you got any idea?

 

Best Regards 

 

 

1 ACCEPTED SOLUTION

Hi,

 

You may refer to my solution this file.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

 

Does this work?

=CALCULATE(sum(Data[Booking Lines]);EDATE(Calendar[Day];-1))

 

If it doe not work, then share the link fro where i can download your file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi!

 

Thanks for you reply.! Not run 

 

I attach a simple file

 

File

 

Thanks

Hi,

 

You may refer to my solution this file.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.