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)

       

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

    amitchandak Anonymous 

    I meant 

    Column 2 = DATEDIFF('Table'[Delivery Date],'Table'[Requested Delivery Date],DAY)

     

    How would you format this?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Yrstruly1 ,

     

     

    Column 2 = IF( DATEDIFF(deliveries[promise_date],deliveries[delivered_date],DAY) <=0 , "Yes", "No")

     

     

     

    https://dax.guide/datediff/

     

     

    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

      This is suppose to count the days, not give a yes or no.

      • Anonymous's avatar
        Anonymous
        Not applicable
        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!