Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
edwardrmiles
Helper III
Helper III

find the scale & precision of a decimal number

How do I work out the precision and scale of a column of decimal numbers using DAX?

 

 

 

 

2 REPLIES 2
v-caliao-msft
Employee
Employee

Hi @edwardrmiles,

 

On source table you can change it on Formating tab.

Capture.PNGCapture1.PNG

On report level, you can set it on Format tab>Data Labels>Display units
Capture2.PNG

 

Regards,

Charlie Liao

Thanks @v-caliao-msft but it's not a formatting issue. I want to return the scale & precision as integers, so 1.23 would return a precision of 3 and a scale of 2

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.