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, I have the following issue Please help,
I have a table with Month, Column A and Column B
How do i get Column Total and sum that based on month.
Solved! Go to Solution.
I am not sure if I understand your scenairo correclty.
You can use count. If you don't want to count duplicated the parts. You caan use distinctcount
Proud to be a Super User!
Hi @Mahadevaraobc,
You could create some dummy data like what ryan_mayu did to illustrate your requirement.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
I think you can just use sum formula. Could you please explain what situation you are in?
Measure = sum(Table3[Column1])
Proud to be a Super User!
Thank You,
I have some data in Column B, which is subcategory of column A, how can i count many are present and sum the value and show that for month.
Could you please provide more info and elaborate it? It's better to provide some sample data and the result you expected.Thanks.
Proud to be a Super User!
I am not sure if I understand your scenairo correclty.
You can use count. If you don't want to count duplicated the parts. You caan use distinctcount
Proud to be a Super User!
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |