Forum Discussion

jackypatel's avatar
jackypatel
Helper I
2 years ago

By default Selection

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. 

 

Need Help

3 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    2 years ago

    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's avatar
      jackypatel
      Helper I
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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