The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a measure which yields a sum of column with decimal places of 3. I would like to get the 3 digit numbers after decimal , so that i use for other calculations. Tips in dax really appreciated.
Example:
measure ouptut 56.236
expected result: 236
Thanks in advance
Solved! Go to Solution.
you can right function.
The measure is
m1= right([your meausure],3)
Note: Your measure should be resticted to have only 3 decimal places.
Kindly give thumps up and mark as solution!!
you can right function.
The measure is
m1= right([your meausure],3)
Note: Your measure should be resticted to have only 3 decimal places.
Kindly give thumps up and mark as solution!!