Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @Antmkjr ,
About recurrence logic in power bi without Power Query, how about using Dax? You can refer these articles:
"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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |