Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team,
Can anyone please suggest how to achieve column B in PBI DAX.
Category | Number | % |
A | 1843 | 16.2% |
B | 299 | 59.3% |
C | 177 | 100.0% |
D | 177 | 62.1% |
E | 110 | 89.5% |
F | 98 | 96.2% |
94 | 0.0% |
I want to mutiply for Category B (Number B2*C2) (1843*16.2% = 299, Category C = (Number B3*C3 (299*59.3% = 177)
Please suggest, this data is in agreegated level. I need any DAX caculation is possible in this
Regards,
Sriku
@Sriku , Refer if window function can help
Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
66 | |
64 | |
57 |
User | Count |
---|---|
171 | |
111 | |
109 | |
72 | |
71 |