Hi All,
Having some issues I am hoping you can help with
I have a Calendar Table that I created in Power BI - basically using the principles in the link here
https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/
In essence, It has a "Date"column from 01/01/2014 to the current date
My data table - called "SellThrough" is linked to the "Calendar" Table via the "Date" Column (Many to One relationship, Single Cross Filter direction, Active relationship)
The data table in question has a column called "Sell through (Units)" which I have two measures calculating from:
Total Sum Sell through = sum(Sellthrough[Sell through (Units)])
Total Sum Sellthrough LY = CALCULATE([Total Sum Sell through],SAMEPERIODLASTYEAR('Calendar'[Date]))
This is to compare last year sales vs this Year sales for the same period
However, when I add any sort of Date filtering (using Date function from my created "Calendar" Table), The Total Sum Sell through is calculated correctly, however Total Sum Sellthrough LY is not and is displaying a result that I don't know where it is coming from!
When in a table it seems to have the correct information in the body, but the total is some random quantity!
I have a sample PBIX file that I can send and I have an image of an example of what is happening if anyone thinks they can shed some light on the issue, however for some reason I can't attach either here
Thanks!
