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.
Hi All,
I have following data and i wanted to calcuate the following variance measures by product.
and i have to show zone wise variances in matrix table.
Data Table
customer, Zone, Product, LY Qty, LY Price, LY Sale, CY Qty, CY Price, CY Sales
Variance Measures by product
Qty Change = if ( And(LY Qty<>0,CY Qty<>0),CY Qty - LY Qty,0)* LY Price
New Prod Val = if ( And(LY Qty=0,CY Qty<>0),CY Qty - LY Qty,0)*CY Price
Disc Prod Val = if ( And(LY Qty<>0,CY Qty=0),CY Qty - LY Qty,0)*PY Price
Price Change = if ( And(LY Qty<>0,CY Qty<>0),CY Price - LY Price,0)*CY Qty
thanks,
Solved! Go to Solution.
Hi @punnas1 ,
Please check if the attached .pbix file is what you want.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi @Icey Thank you
I could not able to download the attaechement, can you please send the link of file.
the below is link of the file
https://drive.google.com/file/d/13NiYWjPCyi7EQmgnqdeDJbtnvhF5f9w8/view?usp=sharing
Hi @punnas1 ,
Please check if the attached .pbix file is what you want.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Yes, I have date column but i had summarized sample data.
Pls help with date column
Hi,
Share the download link of that file.
Hi @Fowmy,
Sample data uploaded in following in link, Pls help
https://drive.google.com/file/d/13NiYWjPCyi7EQmgnqdeDJbtnvhF5f9w8/view?usp=sharing
Thank you.
Hi,
With a Date column, it will become quite cumbersome to write the required measures. Do you not have a Date column?
@punnas1
To getter a better understanding of your question, please share some dummy data with the expected results showing how the calculation needs to be done.
You can save your files in OneDrive, Google Drive, or any other cloud sharing platform and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |