Forum Discussion
Munawar1881
Helper II
Helper IISorting
how can I properly sort the order Status This order status is comming up with DAX formula
Munawar1881 add this caclculated column to the table:
Days Diff = DATEDIFF('Table'[Shipment Date], 'Table'[Actual Shipment Date], DAY)
And then use the sort by column:
Addintg also a link tp the previous question, to make it more clear if anyone else will read this:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/IF-Condition/m-p/2675526#M79918
SpartaBI
Community Champion
Community ChampionMunawar1881 my pleasure 🙂
Munawar1881Helper II
Helper IIhey me again. actually where the "actual shipment date" is blank, I am not able to get exact result. of (status Early, Delay and On Time" if actual shippment is null its mean either its cancled order or late and we could know it by status column "Po Status" can please check this