Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NewbieJono
Post Patron
Post Patron

% Working out Percentage

Hello i have a table as below, i trying to get the % digital and % Non-Digital  for each week commencing 

 

 

Week Commencing DigitalNon- Digital
01/01/200010050
07/01/20007589
14/01/20005050
   
1 ACCEPTED SOLUTION
sirlanceohlott
Advocate III
Advocate III

sirlanceohlott_0-1633441808701.png

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]
)

 

View solution in original post

3 REPLIES 3
sirlanceohlott
Advocate III
Advocate III

sirlanceohlott_0-1633441808701.png

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]
)

 

sirlanceohlott
Advocate III
Advocate III

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.