Forum Discussion

njsimmons82's avatar
njsimmons82
New Member
18 days ago
Solved

Date Issue

Each time I use the created Date or Resolved Date in a new column or measure formula I receive an error that says "A single value for column "Created Date' in table x cannot be determined...."  I am ...
Need Help
power bi
  • ryan_mayu's avatar
    ryan_mayu
    17 days ago

    njsimmons82​ 

    The error occurs because you’re creating a measure, but [Created Date] and [Resolved Date] contain multiple rows. DAX needs an aggregation or a single selected value.

    maybe you can try this

    Resolution Days =

    VAR CreatedDate =

    SELECTEDVALUE('June 1 to Aug 19'[Created Date])

    VAR ResolvedDate =

    SELECTEDVALUE('June 1 to Aug 19'[Resolved Date])

    RETURN

    IF(

    NOT ISBLANK(CreatedDate) &&

    NOT ISBLANK(ResolvedDate),

    DATEDIFF(CreatedDate, ResolvedDate, DAY)

    )

     

    if this does not work, pls provide your sample data and expected output.

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
13 days ago

njsimmons82​ 

If you want resolution days per ticket, make it a calculated column instead:

Resolution Days =DATEDIFF('June 1 to Aug 19'[Created Date],'June 1 to Aug 19'[Resolved Date],DAY)

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    10 days ago

    Hi njsimmons82​ 

    Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.