Forum Discussion
ChrisFromOhio
Helper I
Helper ICalculate Prior Year Sales When Different IDs Have Different Ends Dates
Time calculations with Power BI are the bane of my existance. I have a dataset with sales by item, by day, with multiple retailers. These retailers all have differing end dates for data. For exam...
lbendlin
Super User
Super UserThe closest approximation you can get to is to peg the monthly and yearly reports to an arbitrary date (for example first day in the month or in the year). And then link that to your calendar table which you use for the time "intelligence" functions.