DAX time intelligence functions - no "weekly" options

[Anonymous]

DAX  time intelligence functions appear to be able to deal with days, month, quarters and year, but not weeks e.g.

• there are NEXTDAY, NEXTMONTH, NEXTQUARTER and NEXTYEAR functions but no NEXTWEEK; 
• DATEADD interval can be year, quarter, month, day but not week

Are there any workarounds that could facilaite doing comparisons between this week's sales & last week's, for example?

Thanks!

[Greg_Deckler · Accepted solution]

I have a ton of quick measures dealing with weeks:

https://community.powerbi.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=fals...

Also, check out my Time Intelligence the Hard Way quick measure as well:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Anonymous]

Thanks for this Greg, some really good ideas here!