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
Visualizing RATING Score in Power BI
Calculated Columns vs Measures in DAX
Level: Beginners Original: Feb 2016 It has been many years since Matt wrote his first take on Calculated Columns vs Measures, back in 2014 whe...
Empowering Frontline workers with Power BI
Unlock the Secrets to Power BI Mastery!
Can Marthe fix Patrick's Power BI Report?
Fabric Copilot to help write DAX queries improvements
This update comes with a marked improvement when generating DAX queries and conversationally editing them. This includes overall correctness o...