Forum Discussion
A Single Value For Column Cannot Be Determined
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!
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
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!
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)