Using an IN Condition for multiple values in Power Query (Power BI)
In the example I did not want to specify all the country names one row at a time. This not only takes a long time, but if I had to then make updates it could be painful too. The requirement was for certain countries to have their names and the rest be grouped into “Other Countries” I found this useful...
The post Using an IN Condition for multiple values in Power Query (Power BI) appeared first on FourMoo | Power BI | Data Analytics.
Published on:
Learn moreRelated posts
Watch AI Build a Complete Power BI Report
Deep dive into visual calculations: Adding calculations directly to your Power BI visuals (Generally Available)
Visual calculations (Generally Available) in Power BI, making it easier to add DAX calculations directly to the visual where they’re used.
Optimizing a Sales KPI Report in Power BI for Better Sales Visibility
Optimizing a Sales KPI Report in Power BI for Better Sales Visibility Introduction Sales teams work with a lot of data every day, including le...
Optimising DAX: The Cost of Relationships
Relationships in Power BI aren't free. This post explains how the cardinality of the relationship key determines traversal cost, and why this ...
Power BI reports and Fabric Apps: Expanding how you build on your semantic model data
Power BI reports continue to help analysts build secure, governed BI experiences on semantic models, while Fabric Apps expands what developers...
When to Create a Lookup Table in Power BI
Level: Beginners Original Post: November, 2016 It was only a few months after Power BI was born, that Matt first posted on this topic. At tha...
Power BI Desktop Bridge (Preview)
Power BI Desktop Bridge (Preview)Power BI Desktop Bridge introduces a new way of working, allowing external applications and agents to interac...