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.
i have two tables Confirmation_Advance, Risk Deliveries . both values have similar values . so i created lookup functions based confiremed , Not Confiremed. after lookup i want to fill all blank values as a Not Confiremed.
here i am pasted sample and measures
Confirmation_Advance table:
PO Num Mat Plant PO&mat Confiremd
450 40.1A RS7Z 45040.1A Confiremed
452 40.1B RS7Z 45040.1B Confiremed
450 40.1C LT01 45040.1C Not Confiremed
455 40.1D CHO4 45040.1H Confiremed
458 40.1F MT01 45040.1M Not Confiremed
462 40.1G RS7Z 45040.1K Confiremed
i have created two calculated column
PO Num Mat Plant PO&mat
450 40.1A RS7Z 45040.1A
452 40.1B RS7Z 45040.1B
450 40.1C LT01 45040.1C
455 40.1D CHO4 45040.1H
458 40.1F MT01 45040.1M
462 40.1G RS7Z 45040.1K
455 40.1D CHO4 45040.1H
478 40.1F MT01 45040.1S
482 40.1G RS7Z 45040.1G
PO Num Mat Plant PO&mat Confirmation
450 40.1A RS7Z 45040.1A Confiremed
452 40.1B RS7Z 45040.1B Confiremed
450 40.1C LT01 45040.1C Not Confiremed
455 40.1D CHO4 45040.1H Confiremed
458 40.1F MT01 45040.1M Not Confiremed
462 40.1G RS7Z 45040.1K Confiremed
455 40.1D CHO4 45040.1H ---> want to fill all blank place " Not Confiremed"
478 40.1F MT01 45040.1S
482 40.1G RS7Z 45040.1G
i want to fill Not Confiremed in blank place in confirmation column.
looking for support . thanks in advance .
Solved! Go to Solution.
@THENNA_41 , Do this change in last return
return Switch(true(),
isblank(confirmed ), "Not Confiremed"
confiremed = "" ,not_confirmed,confiremed)
or
return if(confiremed = "" || isblank(confirmed ) ,not_confirmed,confiremed)
I think you can do this all in one step without needing the concatenated columns or calculated tables.
Try this as a new calculated column on Risk Deliveries.
Confirmation =
LOOKUPVALUE (
Confirmation_Advance[Confiremd],
Confirmation_Advance[PO Num], 'Risk deliveries'[PO Num],
Confirmation_Advance[Mat], 'Risk deliveries'[Mat],
"Not Confiremd"
)
@THENNA_41 , Do this change in last return
return Switch(true(),
isblank(confirmed ), "Not Confiremed"
confiremed = "" ,not_confirmed,confiremed)
or
return if(confiremed = "" || isblank(confirmed ) ,not_confirmed,confiremed)
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |