Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
how can I properly sort the order Status
This order status is comming up with DAX formula
Solved! Go to Solution.
@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
@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
Perfect realy got the results. thank you so much for your help
hey 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
Hey, will be available later this evening and ping you here
can you come to the teams chat now?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
32 | |
30 | |
18 | |
18 |