Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
PBIX and test data file attached.
I am using the sameperiodlastyear function to calculate revenue/cost/qty/avg price by part number across YTD time period. I then am calculating the difference between this year and last years avg price * this years qty as 'total price difference'. All of my data looks as expected when in the table, but my totals and if I try to just display the sum of the 'total price difference' looks wildly inaccurate. I understand the card is probably incorrect because without the table structure I am no longer calculating the average prices and differences at the part number level, which is what I need to do. Any help on how to solve would be greatly appreciated.
Hi @Anonymous ,
You could upload the file to onedrive and share the link here.
Or you could just show some sample data and the formulas you used to us.
Best Regards,
Jay
What is the secret to uploading my PBIX and excel data file?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |