Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
11
Views
Topic starter
Hi friends!
I have difficult task. Let's say i have sales table by days and budget table by months. I need to allocate budget to sales so I can visualize it simultaneously.
I've done it in Power Query and created required chart, but this method is really bad for my purposes. I must somehow create a measure.
I saw how this kind of task done with TREATAS function, but excel doesn't has this function, it exist only in PowerBI.
Posted : 06/11/2022 3:34 pm
Hi Vladislav,
You can use this solution, with a YearMonth column added to the tables:
https://www.sqlbi.com/articles/budget-and-other-data-at-different-granularities-in-powerpivot/
Posted : 15/11/2022 10:39 am
