Intellipaat Back

Explore Courses Blog Tutorials Interview Questions

How to control decimal precision on Power BI's DAX

0 votes
2 views
in BI by (11.1k points)

How can I create a "Table1" with field Field1 and "Table2" with Field2

I am creating a calculated field

CField = ROUND(Table1[Field1] * RELATED(Table2[Field2]); 2) 

It works well but didnt give the right values.

How can I make it correct

1 Answer

0 votes
by (22.5k points)

Follow the steps

decimal number

fixed decimal number

The result will be rounded as 3.27

Interested to Learn Power Bi in detail? Come and Join the power bi certification course by Intellipaat.

Check the following youtube link:

Related questions

0 votes
1 answer
Power Bi DAX Decimal Rounding
asked Dec 3, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
How do I use Power BI Desktop with version control?
asked Dec 28, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
How should I write multiple IF statements in DAX using Power BI Desktop?
asked Nov 30, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
DAX to follow the hyperlink - Power BI
asked Jan 11, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Power BI DAX: ALLSELECTED with exception of one column
asked Apr 5, 2021 in BI by Chris (11.1k points)

Browse Categories

© COPYRIGHT 2011-2024 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...