A Single Value For Column Cannot Be Determined

[Yrstruly1]

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])*1 And Days Between = DATESBETWEEN( 'Table'[Dates], 'Table'[Start Date], 'Table[End Date] ), that says cannot find column.

U also cant use Sum with dates.

Seconf dax is 

[Yrstruly1]

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

Im getting error "Invalid token

[amitchandak]

@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

[Yrstruly1]

Its not working. Would you be so kind and test it your side pls?

https://drive.google.com/file/d/1tSpCtPPLyYef7jJFJZI_0fK9HuubMcqR/view?usp=drivesdk

[harshnathani]

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!

[harshnathani]

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]

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

[Yrstruly1]

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

maxx(dates[date]), - 30

Maxx(dates[date])))

Im getting errors for this code, pls assist?

[harshnathani]

Hi @Yrstruly1 ,

Please raise this as a separate topic .

Too many questions on one post.

Regrads,

HN

[harshnathani · Accepted solution]

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]

@amitchandak @harshnathani 

I meant 

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

How would you format this?

[Yrstruly1]

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]

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