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!

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.

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