Time Periods

[Eldin]

Hello,

I've been searching a lot for some good Time Periods in DAX or M Queries, but can't seem to find something that helps me. Everytime there is something missing in order to get the full solution. 

So, what i want is following:

To have a DAX-measure or M-query that shows:

- Today

- Yesterday

- Current week 

- Last week (most important)

- This month

- Last Month 

- Custom

What I have created so far is this, maybe if someone knows what code I need to put in to get "Last week" or "Today". That would be really helpful. 

And I will then filter all my data according to if it corresponds to these periods. 

[Alex_T]

Hi @Eldin ,

Nice find, that Chris Webb stuff is very good, you may also want to check out...

Guy in a Cube, who discusses this stuff, Working with Time Periods in Power BI - YouTube

They reference a Phil Seamark article on this, Row-based Time Intelligence - Phil Seamark on DAX who offer a DAX and TSQL solution and to Fourmoo, Create Dynamic Periods for Fiscal or Calendar Dates in Power BI - Data Analytics | FourMoo and Power... who offer more on M-query solution (and refer to another Seamark article).

Love this stuff, hopefully we'll be having an implementation of this in our Data Warehouse soon, good for the users but also good for devs as it can simplify our measures 🙂

[Eldin · Accepted solution]

I found what I was searching for somewhere else:

https://blog.crossjoin.co.uk/2016/05/30/creating-current-day-week-month-and-year-reports-in-power-bi...

[AlexisOlson]

I think calculation groups might be a better approach to this concept.

Check out these resources:

https://p3adaptive.com/2021/03/calculation-groups-to-the-rescue/

https://www.sqlbi.com/articles/introducing-calculation-groups/