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

[martingaleh]

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

 

[gazpage]

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.

 

[martingaleh]

Yeah, there isn't a real table format thing I can use, maybe if I can add some html, it would be more clear. Can I just copy and paste an image?
Nope, and I can't stick it somewhere. imgur?
http://tinypic.com/r/2s8093l/9

 

[anvg]

Hi
You have a bad structure of your fact table. You need to get a dimention date table for calculation by Power Query. Try https://1drv.ms/x/s!AhKJrasHVtohiStQWvveBJJU11qe.
Regards

 

[martingaleh]

I see what you did. Very clever.