Persistent Variable

[sijukoiply]

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

[psolli]

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

[MattAllington]

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. 

[sijukoiply]

Thanks Matt

Is it possible to share some more details on how to create a persistent constant inside a measure?

[MattAllington · Accepted solution]

take a look here https://www.sqlbi.com/articles/variables-in-dax/