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!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Yrstruly1 ,

 

 

Column = IF(deliveries[delivered_date] <= deliveries[promise_date],"Yes","No")

 

 

 


Regards,

Harsh Nathani


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

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

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

Did you use my data to create that, what was the issue?

 

How would i format this with the data i provided?

 

Column 2 = DATEDIFF('Table'[Delivery Date],'Table'[Requested Delivery Date],DAY)
  • Yrstruly1's avatar
    Yrstruly1
    Icon for Helper I rankHelper I
    6 years ago
    Column 2 = DATEDIFF('Table'[Delivery Date],'Table'[Requested Delivery Date],DAY)