How to create an Excel table from a DAX (Power BI) query to be used for Data Validation
I had a requirement where the customer wanted to make sure that the right user could only see the colour from the stock item assigned to them. Essentially using the Excel file for Row Level Security. For the Row level security to work correctly it required the colour name to be an exact match. For me to ensure that this...
The post How to create an Excel table from a DAX (Power BI) query to be used for Data Validation appeared first on FourMoo | Power BI | Data Analytics.
Published on:
Learn moreRelated posts
What is Info DAX Function in Power BI (48/50)
Power Bi Calendar Table in Less Than 10 Seconds
A calendar table is essential for working with time-based data in Power BI. Whether you're analysing trends, creating time intelligence measur...
Power BI Copilot: Where Are The CUs Consumed?
If you’ve looked into using Copilot with Power BI, you’ll know that you need a capacity to use it: a P1/F64 or greater. Something ...
Convert rows to columns using Power Query – Excel and Power BI
If you get data in a single column with multiple records, you can easily convert it to multiple columns using Power Query. Watch and Try with ...