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...
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
Super User
Super UserIn that case you would have to sever the link to the calendar table, and use the explicit measures.