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!

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!

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

      Rolling Days 30 = Calculate([total sales] ,Datesbetweendates(dates[date])

      maxx(dates[date]), - 30

      Maxx(dates[date])))

       

      Im getting errors for this code, pls assist?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Yrstruly1 ,

         

        Please raise this as a separate topic .

         

        Too many questions on one post.

         

        Regrads,

        HN