Forum Discussion
Anonymous
6 years agoNot applicable
DAX time intelligence functions - no "weekly" options
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!
I have a ton of quick measures dealing with weeks:
Also, check out my Time Intelligence the Hard Way quick measure as well:
2 Replies
- Greg_DecklerCommunity Champion
I have a ton of quick measures dealing with weeks:
Also, check out my Time Intelligence the Hard Way quick measure as well:
- AnonymousNot applicable
Thanks for this Greg, some really good ideas here!