Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
Is there any way we can create a persistant variable OR add or modify data in a table using DAX or any other method?
Thanks
Siju
Solved! Go to Solution.
take a look here https://www.sqlbi.com/articles/variables-in-dax/
Hi,
Writeback to Tabluar with both Import mode and Direct query is fully supported with Visual Planning from Power ON. There is a great video here to get you started. http://poweronbi.com/powerbi-visual-planning/
You can also load data from Power BI to SQL with their solutions: http://poweronbi.com/2017/06/power-update-from-power-bi-desktop-to-sql-server
Power ON also has a Table Editor that lets you edit SQL Tables in Power BI Service directly. http://poweronbi.com/visual-table-editor/
Contact info is feedback@poweronbi.com
Visual Planner turns Power BI into a fully fledged Goal Seek and Planning, Budgeting and Forecasting solution.
Per Solli
You can create a persistent variable inside a measure (persistent constant actually). You can't change values in a table. It was announced at The Microsoft Data Insights Summit that writeback is coming soon.
Thanks Matt
Is it possible to share some more details on how to create a persistent constant inside a measure?
take a look here https://www.sqlbi.com/articles/variables-in-dax/
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
211 | |
83 | |
64 | |
60 | |
56 |