Infinity Value Issue

[cham]

Hi,

When I divide 20746 / 0.092 it will give me infinity value icon. But I want to get the real value to 2 or 3 decimal places.

How can I do that?

Regards,

Cham.

[v-piga-msft]

Hi @cham ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample and your desired output so that we could help further on it.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @cham ,

Where do you have this issue? Power Query or DAX?

By my test with dax and power query, I get the output below.

Do you have the same result?

If not, could you share your result and your desired output so that we could help further on it?

Best  Regards,

Cherry

[cham]

Thank you so much