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.
Hello there.
Here's my question with a dummy file :
A (colum) = year
B = a reference number for an event
C = the income
D = unique number within an event (can have one or more unique number)
E = is this event a type EV or not.
I would like to know for the % of EV or not based on the B column (B must be distinct count, but i'm stuck here.)
Solved! Go to Solution.
Hi Paaaaaaan,
If B Column is not unique, then you can combine two or three column and have a count of that column to calculate the percentage.
With this calculated column, you can proceed in calculating the %.
Regards,
Pradeep
Hi Paaaaaaan,
If B Column is not unique, then you can combine two or three column and have a count of that column to calculate the percentage.
With this calculated column, you can proceed in calculating the %.
Regards,
Pradeep
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |