Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |