Forum

% between chosen fi...
 
Notifications
Clear all

% between chosen fileds

2 Posts
2 Users
0 Reactions
80 Views
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team,

I have figures from different table and I can put together in Power BI as attached.

I just want to have another column on Power BI visual as follows:

Percentage of OccupiedBed = OccupiedBed/AvailableBed.

Is that possible to do on Visual.

Thank you.

Please note, I have OccupiedBed from our FinanceDataBase and AvailableBed from a simple excel worksheet.

Regards,

AyeOccupancy26032019.PNG

 
Posted : 27/03/2019 1:33 am
(@mynda)
Posts: 4761
Member Admin
 

Assuming it's just a regular table you can add a measure to the 'Values' area that calculates the % of Occupied Beds.

Mynda

 
Posted : 27/03/2019 6:29 am
Share: