Time Intelligence - Comparing Day of Week of Previous Month

[sebasjun]

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 

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 

[Ashish_Mathur]

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.

[sebasjun]

Hi!

Thanks for you reply.! Not run 

I attach a simple file

File

Thanks

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution this file.

Hope this helps.