Hi all,
i am trying to change Not confirmed to pending particular valuie. i have created two calcualted column value in the table
Risk Delivers column Measure:
Risk Deliveries = IF(OR('Risk Deliveries'[Rule Type] = "Lack",'Risk Deliveries'[Rule Type] = "Urgent"),"Risk Delivery",IF(OR('Risk Deliveries'[Rule Type] = "Standard Overdue",'Risk Deliveries'[Rule Type] = "Old Overdue"),"Risk Delivery",IF('Risk Deliveries'[Rule Type] = "Urgent Overdue","Risk Delivery",IF('Risk Deliveries'[Rule Type] = "Urgent","Risk Delivery", IF('Risk Deliveries'[Rule Type] = "Purchase Requisition OVR","Risk Delivery",""))))
Confirmation Column measure :
Confirmation =
var confiremed = LOOKUPVALUE('Confirmed table'[Confirmed],'Confirmed table'[PO & Material],'Risk Deliveries'[combi confirmation])
var not_confirmed = LOOKUPVALUE('Not Confirmed table'[Confirmed],'Not Confirmed table'[PO & Material],'Risk Deliveries'[combi confirmation])
return if(confiremed = "",not_confirmed,confiremed)
Risk Delivers Rule Type Confirmation
Risk Deliveries Lack Not confiremed
Risk Deliveries Lack confiremed
Risk Deliveries Urgent Not confiremed
Risk Deliveries Urgent Not confiremed
Risk Deliveries Purchase Requisition OVR Not confiremed
Risk Deliveries Purchase Requisition OVR Not confiremed
Now i want change Rule Type "Purchase Requisition OVR " confirmation value " Not confiremed " to pending . i am tried with measure below measure
Confirmation =
var confiremed = LOOKUPVALUE('Confirmed table'[Confirmed],'Confirmed table'[PO & Material],'Risk Deliveries'[combi confirmation])
var not_confirmed = LOOKUPVALUE('Not Confirmed table'[Confirmed],'Not Confirmed table'[PO & Material],'Risk Deliveries'[combi confirmation])
//return if(confiremed = "",not_confirmed,confiremed)
return Switch(true(),
isblank(confiremed ) , "Not Confiremed",'Risk Deliveries'[Rule Type]="Purchase Requisition OVR","Pending",
confiremed = "" ,not_confirmed,confiremed)
i am not getting the value .
Looking for support . thanks in advance .
