topic Re: Sorting in DAX Commands and Tips

Sorting

Munawar1881 — Tue, 02 Aug 2022 12:26:21 GMT

how can I properly sort the order Status

This order status is comming up with DAX formula

Re: Sorting

SpartaBI — Tue, 02 Aug 2022 12:31:16 GMT

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

Showcase Report – Contoso By SpartaBI

Re: Sorting

Munawar1881 — Wed, 03 Aug 2022 08:13:20 GMT

Perfect realy got the results. thank you so much for your help

Re: Sorting

SpartaBI — Wed, 03 Aug 2022 08:14:18 GMT

Munawar1881 my pleasure 🙂

Re: Sorting

Munawar1881 — Wed, 03 Aug 2022 10:52:50 GMT

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

Re: Sorting

SpartaBI — Wed, 03 Aug 2022 10:58:19 GMT

Hey, will be available later this evening and ping you here

Re: Sorting

SpartaBI — Wed, 03 Aug 2022 11:06:36 GMT

can you come to the teams chat now?