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,
may you please help me to find out the correct way of calculation monthly sales ratio per quarter sales?
I have got 3 tables: Calendar, Sales(includes transaction date, qty, sku), Product(sku,price per unit)
i've used for:
MSales = sumx('Sales';'Sales'[qty]*RELATED('Product'[price]))
QSales =
Solved! Go to Solution.
hi @Anonymous
Just please make sure this measure[Ratio Month to Quarter] is percenet or keep two decimal places,
It is currently of Whole number, so it always show 0.
Regards,
Lin
hi @Anonymous
Just please make sure this measure[Ratio Month to Quarter] is percenet or keep two decimal places,
It is currently of Whole number, so it always show 0.
Regards,
Lin
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak, yes, of course.
https://dropmefiles.com/Wp7wO - pbix is located here.
Thank you in advance.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |