Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
Hi I have exactly the same issue. Did you find a resolution to this?
Figured out how to add an image
Hi @Bridgett ,
Could you please offer your pbix file and post your desired result if possible? You could upload your file to Dropbox or OneDrive and send the link here that I could have a test for you.
Regards,
Daniel He
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
87 | |
66 | |
52 | |
46 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |