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 UserFrom your sample data it looks like you already implemented the best possible option.
What else do you need to improve?
ChrisFromOhioHelper I
Helper ISee above. If an item did not have sales in a month the year prior and I am looking at item level sales, I will see only a blank for that month this year. If I have sales last year but not this year, that line item does not show up. This was only a sample dataset, but the original one has far more retailers and items.
- lbendlin
In that case you would have to sever the link to the calendar table, and use the explicit measures.