Forum Discussion
Incorrect Results using DAX
Hello folks, I have a table in which there are three columns. First column is Order Status which has either of the two values Delivered or Not Delivered. The second column, Delivery date, which has ...
Hi,
Write this calculated column formula
Column = 1*(Data[order_delivered_customer_date]<=Data[order_estimated_delivery_date])Hope this helps.
Hey Ashish,
How did you convert datatype to date and time format. I've tried it at my end but unable to do so and hence I'm getting errors. Please guide.
I did not do anything. When i pasted the data from Excel to PowerBI, the data type was picked up correctly.