Forum Discussion

Yrstruly1's avatar
Yrstruly1
Icon for Helper I rankHelper I
6 years ago
Solved

A Single Value For Column Cannot Be Determined

Un trying to use this measure and im getting the above error. Column = IF('Table'[Delivery Date]<='Table'[Requested Delivery Date],"Yes","No")   I also tried Column = (Dates2[Date1] - Dates2[Date2...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Yrstruly1 ,

     

    Column 2 = DATEDIFF(deliveries[promise_date],deliveries[delivered_date],DAY)

     

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)

    Did I answer your question? Mark my post as a solution!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Yrstruly1 , This you can create as a column not meaure

Column = IF('Table'[Delivery Date]<='Table'[Requested Delivery Date],"Yes","No")

 

measure can be

 

measure = sumx('Table, IF('Table'[Delivery Date]<='Table'[Requested Delivery Date],1,0))

measure = IF(min('Table'[Delivery Date])<=max(('Table'[Requested Delivery Date]),"Yes","No"), here row context is very important