Forum Discussion

njsimmons82's avatar
njsimmons82
New Member
14 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
    14 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.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
14 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.