Recurrence how to solve without power query

[Antmkjr]

Is there anyway to solve a recurrence logic in power bi without Power Query.

Can I export my measures(Table Visual- contains measures on multple tables) into SQL and then do the calculations there and then bring it back or something

I would also want the entire process to be automated.

[v-yingjl]

Hi @Antmkjr ,

About recurrence logic in power bi without Power Query, how about using Dax? You can refer these articles:

1. Previous Value (“Recursion”) in DAX 
2. Recursive Calculations in PowerPivot using DAX 
3. Recursion-in-dax 

"Can I export my measures(Table Visual- contains measures on multple tables) into SQL and then do the calculations there and then bring it back or something"

I'm afraid not, you can try to using DAX to write related measures in power bi directly referring to the above articles.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Don't "fight the API".  Use Power BI and Power Query for what it is designed to be used.

Power BI is not an ETL tool. Power Query kinda sorta is, but only in a one way street kind of way.