OUTSTANDING Date due of Delivery date vs Receive Order Date

[Anonymous]

Hi Team

I had a question .

Details Below

any suggestion of DAX

Thanks

Shybs

[amitchandak]

Try something like that. if both are in same table, create a new column

Switch(true (),
isblank([rcdOrder]), "Received Order blank",
isblank([rcdOrder]) && isblank([delivery]), "Check",
[rcdOrder]<today() && isblank([delivery]) ,"Outstanding",
[rcdOrder]>=today() && isblank([delivery]) ,"Not deilvered yet",
[rcdOrder]<today() && ([delivery]) <<today(),"OK"
,"Outstanding"
)

If both are in different table

then enclose the with firstnonblank() like firstnonblank([rcdOrder],blank()) and create a measure. But in display row conext would be important

Refer:

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...

[Anonymous · Accepted solution]

Thanks for ur respond

I tried ur DAX , but i got an issue for calculating month .

so i tried to test with my own DAX

KPI-Delivery = if(ISBLANK(PREE[Rcv Order]),"RCV ORDER BLANK",
IF(ISBLANK(PREE[Rcv Order]) && ISBLANK(PREE[Last Delivery for POD]),"CHECK", IF(ISBLANK(PREE[Last Delivery for POD]),"NOT DELIVERED YET",
if(PREE[Last Delivery for POD].[Month]>PREE[Rcv Order].[Month],"OUTSTANDING","ONTIME"))))

Regards

syaiful

[Anonymous]

both are different table