Forum Discussion
Replace multiple values with a conditional column not working?
Hi, if in your situation, i would create a 'Site' Lookup table manually in Excel or Power BI itself(if it's a small model).
In Power Query make sure all Site_ID are of type Text. Then in Power BI Model view, create one-to-many relationship between your Lookup table and Fact table. Now your 'Site' Lookup table will be working as a dimension table.
With your model being set up this way, the logic is reusable, scalable, and easier to maintain.
Hope it helps:)
Hi, if in your situation, i would create a 'Site' Lookup table manually in Excel or Power BI itself(if it's a small model).
In Power Query make sure all Site_ID are of type Text. Then in Power BI Model view, create one-to-many relationship between your Lookup table and Fact table. Now your 'Site' Lookup table will be working as a dimension table.
With your model being set up this way, the logic is reusable, scalable, and easier to maintain.
Hope it helps:)