Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
Input : Col1 Col2 Col3
AA $1,045 xxx
BB $0 yyy
Col2 : Decimal number, currency format.
The matrix must display the Col2 value as such if its > 0 and if its 0 then 0 without the $ symbol.
your input please?
Solved! Go to Solution.
IF(<value>=0, FORMAT(<value>, "General Number"), FORMAT(<value>, "Currency"))
IF(<value>=0, FORMAT(<value>, "General Number"), FORMAT(<value>, "Currency"))
Thank you so much, its working.
I did it using power query,
Col2 => Decimal , Col2_copy => text
if [Col2_copy] = "0"
then "0"
else Text.Combine(
{ "$",
[Col2_copy
})
Output : $1045 , 0 [ since the datatype of the column changed to text , "," are gone. Is there any way to copy the data as such including its format?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
14 | |
12 | |
10 | |
10 |