Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I had a number got from SQL, and I'd like to round down it. In Excel is pretty easy. I'll show an example:
A1=830 = ROUNDDOWN(A1/100;0) =8
A2=1020 = ROUNDDOWN(A2/100;0)=10
I need it in the new measure, or "M languege" because I'll use it in order to plot a graph.
Thanks,
Solved! Go to Solution.
Hi @Anonymous,
It's this one in M.
Number.RoundDown([Column1] / 100)
And this one in DAX.
Column = ROUNDDOWN([Column1]/ 100, 0)
Please refer to the snapshot below.
Best Regards,
Dale
I've tried it but didn't work.
Hi @Anonymous,
It's this one in M.
Number.RoundDown([Column1] / 100)
And this one in DAX.
Column = ROUNDDOWN([Column1]/ 100, 0)
Please refer to the snapshot below.
Best Regards,
Dale