Power pivot question I can't even articulate in a title

martingaleh

Board Regular
Joined
Jul 18, 2011
Messages
82
I have data like:

Measure date1 date2
1 1 2
2 1 2
4 2 2
8 2 1
16 1 1

And I'd like to make a table like

Dates
1 2
date1 1 3
date2 8 4


How would I go about doing that? The only way I can think of doing it is by unpivoting the data, but Surely there's something else. Also, does anyone actually use power pivot for joins or do you just do all the joins in power query and keep power pivot for analysis and aggregation purposes. It seems the power pivot join is just too slow so it's just better to fold it up explicitly
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

gazpage

Active Member
Joined
Apr 17, 2015
Messages
393
I can't understand your transformation at all. Can you explain in plain English how you get from one to another? Unpivotting is a standard transformation and often it's worth using it to go from short and wide to long and thin table structure.

I believe Power Pivot does have the ability to do joins in DAX, but 99 times out of a 100 you should be using a relationship in Power Pivot rather than a join. It's lightning fast. If I really needed to join for some reason I would probably do it in Power Query.
 

Forum statistics

Threads
1,171,650
Messages
5,876,684
Members
433,205
Latest member
jabin1991

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top