Forum Discussion

Elisa112's avatar
Elisa112
Icon for Helper V rankHelper V
2 years ago
Solved

Quick measure output in wrong format

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

  • Elisa112's avatar
    Elisa112
    2 years ago

    Hiya

    I have checked and still giving the incorrect output

5 Replies

  • Tom_Y's avatar
    Tom_Y
    Icon for Advocate II rankAdvocate II
    2 years ago

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

     

      • Tom_Y's avatar
        Tom_Y
        Icon for Advocate II rankAdvocate II
        2 years ago

        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.

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    2 years ago

    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