Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
53 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
114 | |
44 | |
44 | |
28 | |
22 |