Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello i have a table as below, i trying to get the % digital and % Non-Digital for each week commencing
Week Commencing | Digital | Non- Digital |
01/01/2000 | 100 | 50 |
07/01/2000 | 75 | 89 |
14/01/2000 | 50 | 50 |
Solved! Go to Solution.
Total Channels =
SUM('Example Table'[Digital]) + SUM('Example Table'[Non-Digital])
Digital % =
DIVIDE(
SUM('Example Table'[Digital]),
[Total Channels]
)
Non-Digital % =
DIVIDE(
SUM('Example Table'[Non-Digital]),
[Total Channels]
)
Total Channels =
SUM('Example Table'[Digital]) + SUM('Example Table'[Non-Digital])
Digital % =
DIVIDE(
SUM('Example Table'[Digital]),
[Total Channels]
)
Non-Digital % =
DIVIDE(
SUM('Example Table'[Non-Digital]),
[Total Channels]
)
Hey @NewbieJono ,
I'd like to help, so would you, so could you clarify your ask?
You'd like the % of Digital & % Non-Digital in comparison to the prior week?
No i just need to show the split each wek
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |