By default Selection

[jackypatel]

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]

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]).

[jackypatel]

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]

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