Skip to main content

Notifications

Power Up Program - Visualize data with Power BI
Unanswered

Error in Mquery_if else condition

Posted on 27 Nov 2024 10:38:38 by
I have 2 columns "Unit of Measure" and "Value".
There are two unit of Measures: PPM and %. I want to create a new column that wherever unit of measure is %, the result is value*10000, if unit of measure is PPM, result is value. The formula is giving the result but when i try to put filter, it's giving an error: Convert Data into number, Details: Balance.
I tried changing data type into number, still i am unable to filter.
 
If i am not adding "If [Unit of measure]="%" then [value]*10000, then formula and filters are working fine. Please help me with solving this as i want to add this condition

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,151

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,845

Leaderboard

Featured topics