I have so many situations where I need to roll up a roll up field (i.e. Parent record sums the total of a child record, which is summing the grandchild) in the Dataverse... and I really don't want to have to set up lots of real time workflows to manage this. Therefore I'm wondering if SQL can be used within Dataverse? I know that soon PowerFx can be used with calculated columns but it's not even in preview yet...
Hi @davidyc ,
Quick answer is "no" it can not be used, wish it could! I usually recommend to look at Power BI for this type of situation and I am waiting on Power Fx to help with a number of these situations.
Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew