By default Selection

jackypatel · ‎11-16-2023

I have one "Vendor List". It is connected with My "PDI DASHBOARD" file. See the Below Image

In vendor List every Month, new Vendor is added. So i have to add Manualy Vendor name & Mention is type (Strategic or Non Strategic).

My Question is - If new venor is added, than this type will be "Non Strategic" by default.

Plz helm me for the same.

AmiraBedh · ‎11-16-2023

Using PowerQuery :

Click on Add Column in the menu.
Choose Custom Column.
In the formula, write something like: if [VendorType] = null then "Non Strategic" else [VendorType]. This formula assumes that the column where you specify the vendor type is named 'VendorType'

Using DAX :

Create a Calculated Column:

Go to the Data view.
Right-click on your table and select New column.
Your calculated column syntax: VendorType = IF(ISBLANK([VendorType]), "Non Strategic", [VendorType]).

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

jackypatel · ‎11-16-2023

Not working, Beacause Vendor Name is not there. So how its select his Vendor type.

In simple way-- My total Number of Vendor is 50 At present & Next month 2 Vendor is added than Vendor is 52. How it select Other 2 vendor name for his Vendor type.

Kindly guide me.

Anonymous · ‎11-20-2023

Hi @jackypatel ,

Since you have created the relationship between the table 'Vendor List' and 'PDI' base on the field [Vendor], you can create a table visual with the below Fields settings to get it:

Best Regards