Forum Discussion
Difference Between Budget and Real - Two Datasets
Good Morning My Friends. I'm new to PBI and did not find the solution to my problem seaching in the web. I'll try to explain to you: What I have are two differents Datasets, the first one...
Hi Anonymous ,
I think your Table.Group in Power Query idea sounds fine. This is the way that I would solve the problem if I didn't need the extra detail from the Real table as it would push more calculation and processing away from the data model. I'd almost be tempted to put the variance column into Power Query as well, then just use a SUM([Variance]) measure to display the variance value.
Pete
Hi Anonymous
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?
If not, please feel free to let me know.
Best Regards
Maggie