Forum Discussion

sgmanjunath's avatar
sgmanjunath
Frequent Visitor
3 years ago

i have to convert a SQL update statment to PBI

Below are few update stament that i have to convert to PBI DAX and i am unable to find an option to create this logic. In the Fact table and BMT i have created a key column with geo and membership. ...
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago
 update stament that i have to convert to PBI DAX

Absolutely not.  Power BI is a reporting tool, not a data management tool. Currently the data writeback capabilities are miserable.

 

You can fudge some of this in Power Query, or with R/Python code in visuals.  But that will always be a very unreliable hack.

sgmanjunath's avatar
sgmanjunath
Frequent Visitor
3 years ago

Thanks for your response.

 

I was able to find a solution for this. i created 2 varieables for hardware and services membership and then update using if condion.