Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Recurrence how to solve without power query

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.

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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.

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Anonymous ,

    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.