Forum Discussion
Solved
Custom Week filter
Sorry if this is a simple question however, I am new to Power BI, Power Query, DAX. I do however have expereince with sql, php, excel, etc. My company runs a custom sales week Tuesday - Monday. ...
This works
EstimateWeek =[Estimate Date Year Number]*100+Date.WeekOfYear([Estimate Date],2)
TodayWeek=Date.Year(DateTime.LocalNow())*100+Date.WeekOfYear(DateTime.LocalNow(),2)
PreviousSalesWeek=if [EstimateWeek]-[TodayWeek]=-1 then 0 else 1
However I'm going to have an issue on the year transition.
GilbertQ
Super User
Super UserHi there,
You could look at my data story and the associated blog post, which would enable you to create any periods that you want. Which you could then use to easily filter, as well as create measures.