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