topic Re: Formatting issues in DAX Commands and Tips

Formatting issues

arniet — Wed, 01 Jul 2020 01:55:32 GMT

Hi, when creating a measure, some instances I am unable to have the option to select the format of my measure, in particular, I want to have zero decimal places as shown below. Is it because the numerator and denominator both have differring formats so it confuses Power BI when they are used in a new meausre via DIVIDE DAX?

kind regards

arnie

Re: Formatting issues

AntrikshSharma — Wed, 01 Jul 2020 11:44:14 GMT

That could be an issue with the latest version of PBI, I have also faced a couple issues in June release that were not in the previous versions. Try switching applications and it might get unfreezed.

Re: Formatting issues

Anonymous — Wed, 01 Jul 2020 11:20:26 GMT

Hi arniet ,

You are trying to return an integer and a string value in the same Measure.

Try Like this measure

Net Sales per order = Divide ( [MTD Curr [Net Sales] , [MTD Curr] , BLANK())

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

Re: Formatting issues

Anonymous — Thu, 02 Jul 2020 10:23:16 GMT

"unfreezed" does not exist in English. Please use unfrozen. Thanks.

Best
D

Re: Formatting issues

AntrikshSharma — Thu, 02 Jul 2020 10:31:16 GMT

Anonymous Thank you for pointing out a grammatical error on a PBI forum.

Re: Formatting issues

Anonymous — Thu, 02 Jul 2020 10:34:53 GMT

Dear AntrikshSharma.

No need to be sarcastic. Even on a PBI forum it pays to be correct.

Best
D

Re: Formatting issues

AntrikshSharma — Thu, 02 Jul 2020 10:41:40 GMT

The ultimate goal is to make sure the user's query is resolved, language is just a bridge to ensure that communication is done properly, if a group of people decide that the new synonym is unfreezed soon it will be accepted worldwide, I have studied English since first day at school, but still it is impossible to remember tense for each word, when I come online I try to solve 5-10 questions and in that time frame I can't pay heed to my English. I am sure the OP understood what I meant by unfreezed 🙂

Re: Formatting issues

Anonymous — Thu, 02 Jul 2020 11:55:39 GMT

Interestingly, I have not studied English since my first day at school but I almost always get it right (without paying any heed to it as I type) and solve not fewer problems than you. But I really don't have time to enlarge upon why proper English is a good-to-have skill. You do as you please.

Best
D

Re: Formatting issues

arniet — Thu, 02 Jul 2020 23:10:13 GMT

Thank you everyone for your input and resolving my query, much appreciated!!

Re: Formatting issues

Anonymous — Fri, 03 Jul 2020 07:01:01 GMT

Hi arniet ,

Thanks.

Please mark the correct solution as Solved.

Will help others in the community.

Thanks