Forum Discussion
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])*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
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!
12 Replies
Column 2 = DATEDIFF('Table'[Delivery Date],'Table'[Requested Delivery Date],DAY)
Im getting error "Invalid token
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
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
