Calculating measures over a non-standard week

[MrBenn]

I need to be able to calculate measures where the week is defined as Friday to Thursday.  I have a calendar in which I'd like to concatenate the start and end dates for these periods as a filter also. Can anyone help?

e.g. "28th February to 5th March"

Thanks for any help

[ibarrau · Accepted solution]

Hi!, you can do this. In order to build calculations in date you need a Calendar Table to accomplish Time Intelligence. You can check how to do one here:

https://blog.ladataweb.com.ar/post/185012464051/data-modeling-como-hago-una-tabla-fecha

In your Date table (with power query) you can use something like this:

Date.WeekOfYear([DateColumn], Day.Friday)

 You can also add this week with dax using WEEKNUM

Regards, hope this helps