Quick measure output in wrong format

[Elisa112]

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

[v-zhangti]

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

[Tom_Y]

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

[Elisa112]

Hi Tom

Yes I have tried, no luck

[Tom_Y]

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.

[Elisa112 · Accepted solution]

Hiya

I have checked and still giving the incorrect output