topic Re: Quick measure output in wrong format in DAX Commands and Tips

Quick measure output in wrong format

Elisa112 — Fri, 15 Dec 2023 11:43:14 GMT

Hello

I have created a couple of quick measures to calculate the difference in two dates for a specific usergroup, as below

1. WorkingDaysDiff = NETWORKDAYS(SELECTEDVALUE('Engagements'[Referral Date]), (SELECTEDVALUE('Engagements'[Eligibility Confirmation Date])))

2. KPI2test = NETWORKDAYS(SELECTEDVALUE('Engagements'[Eligibility Confirmation Date]), (SELECTEDVALUE('Meeting List'[Date/Time])))

Now the first measure outputs in the correct whole number format (e.g 1) , whereas the second measure provides the out put as (eg 32245) rather than (1,2,3,4 etc).

I do not understand why the first measure outputs correctly and the second one does not. I have tried changing the format on the ribbon etc to no avail. Does anyone have a solution for this, I have been away from powerbi for a while so Im a bit rusty!

Thanks in advance

Re: Quick measure output in wrong format

Tom_Y — Fri, 15 Dec 2023 13:37:05 GMT

Have you tried "Measure Tools" after clicking your Measure?

Re: Quick measure output in wrong format

Elisa112 — Fri, 15 Dec 2023 15:32:47 GMT

Hi Tom

Yes I have tried, no luck

Re: Quick measure output in wrong format

Tom_Y — Fri, 15 Dec 2023 18:31:32 GMT

have you checked the format of that column 'Meeting List'[Date/Time] whether it's a date or it's "date time".

Sometimes I got funny result due to incorrect data format in Power query.

Re: Quick measure output in wrong format

Elisa112 — Wed, 20 Dec 2023 15:12:02 GMT

Hiya

I have checked and still giving the incorrect output

Re: Quick measure output in wrong format

v-zhangti — Thu, 28 Dec 2023 10:00:46 GMT

Hi, Elisa112

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it. If this fails to resolve, can you provide more example data and desired output?

Best Regards