Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
User | Count |
---|---|
57 | |
21 | |
19 | |
18 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |