topic Re: A Single Value For Column Cannot Be Determined in DAX Commands and Tips

A Single Value For Column Cannot Be Determined

Yrstruly1 — Wed, 15 Jul 2020 17:50:59 GMT

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

Re: A Single Value For Column Cannot Be Determined

Yrstruly1 — Wed, 15 Jul 2020 17:56:39 GMT

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

Im getting error "Invalid token

Re: A Single Value For Column Cannot Be Determined

amitchandak — Wed, 15 Jul 2020 18:14:06 GMT

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

Re: A Single Value For Column Cannot Be Determined

Yrstruly1 — Wed, 15 Jul 2020 19:42:16 GMT

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

Re: A Single Value For Column Cannot Be Determined

Anonymous — Thu, 16 Jul 2020 04:58:37 GMT

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!

Re: A Single Value For Column Cannot Be Determined

Yrstruly1 — Thu, 16 Jul 2020 05:43:02 GMT

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)

Re: A Single Value For Column Cannot Be Determined

Yrstruly1 — Thu, 16 Jul 2020 05:45:47 GMT

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

Re: A Single Value For Column Cannot Be Determined

Yrstruly1 — Thu, 16 Jul 2020 05:48:23 GMT

amitchandak Anonymous

I meant

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

How would you format this?

Re: A Single Value For Column Cannot Be Determined

Anonymous — Thu, 16 Jul 2020 05:55:19 GMT

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!

Re: A Single Value For Column Cannot Be Determined

Yrstruly1 — Thu, 16 Jul 2020 07:46:10 GMT

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

Re: A Single Value For Column Cannot Be Determined

Anonymous — Thu, 16 Jul 2020 08:36:46 GMT

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!

Re: A Single Value For Column Cannot Be Determined

Yrstruly1 — Thu, 16 Jul 2020 12:44:20 GMT

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

maxx(dates[date]), - 30

Maxx(dates[date])))

Im getting errors for this code, pls assist?

Re: A Single Value For Column Cannot Be Determined

Anonymous — Thu, 16 Jul 2020 13:08:42 GMT

Hi Yrstruly1 ,

Please raise this as a separate topic .

Too many questions on one post.

Regrads,