I am a very new to Power BI, so I would greatelly appreciate any help!
I am trying to create a new measure "WHS Modification":
I have four columns: Warehouse,Vendor, Location, Item
The column Warehouse need to be modified by creating new column called "WHS Modification", but the changes in Warehosue column need to be done only for some records based on Product and Vendor:
If Vendor="PBC" and Location="OF" and Item in (Cakes, Cookies) then WHS=ABC If Vendor="PBC" and Location = "OF" and item not in (Cakes, Cookies) then WHS=DEF If Vendor not "PBC" and "Loation"="OF" then "SCC" else Warehouse data for the specific combinations of Vendor, Location and WHS.