topic Re: subtracting 100 from each value in another column in DAX Commands and Tips

subtracting 100 from each value in another column

Jay2022 — Tue, 30 Jul 2024 14:42:41 GMT

i have % increase in one column eg 60%, 80% for various organisations and i want to show the remainder eg 40% and 20% in another so i can show stacked bar charts etc how do i create a column which deducts 100 from each percentage

i tried something like % remaing = 100 - % increase but that didn't work

Any help greatly appreciated

Re: subtracting 100 from each value in another column

Greg_Deckler — Tue, 30 Jul 2024 15:12:43 GMT

Jay2022 Try 1 - [% increase]. If that's not it, then post sample data.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: subtracting 100 from each value in another column

Arjun_TK — Tue, 30 Jul 2024 15:36:28 GMT

You can use below dax function to get your expected result.
% Remaining = 100 - [% Increase]

Replace % Increase with the actual name of your column if it differs

If your percentages are in decimal format (like 0.60 instead of 60%), adjust the formula accordingly:

% Remaining = 1 - [% Increase]

then use this in your barchart,hope this works.

Re: subtracting 100 from each value in another column

Jay2022 — Wed, 31 Jul 2024 07:52:50 GMT

Great thank you