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.
https://www.dropbox.com/s/5s52nafr57orbsd/Fruit%20Basket-Percentage%20of%20total.xlsx?dl=0
Hello ,
My question is very basic. I have two columns (Sold date and Fruit type). I would like to write a DAX formula to express what was the % of each fruit sold in a given period (per week, per month or per year).
Thanks for your time in advance.
Qmars
Hi @qs,
Please take a look at following link which about create a calculation table to store detail records based on current table:
Spread revenue across period based on start and end date, slice and dase this using different dates
After crate calculate table and build relationship to original table, you can add custom column with specific categories(week, month, year). Then you can simply use these columns and original records to create visualizations.
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Thanks for your suggestion, but the solution you're suggesting doesn't answer my question. I have a column of different categories and I simply want to express % of each different category. For example, if we have 20 apples and 80 oranges sold across of a given time span, I'd like to express apple sold, as 20% and oranges at 80% for that time span.
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 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |