Forum Discussion
DAX, joining a table with itself
Hi I have a DAX problem, which I simplified. See link to pbix The Facts table has multiple rows per date per product. First I have to group on product and date. And then I have to get the two dis...
Hi Anonymous
Please refr to attached sample file amended with the solution
Thnx tamerj1
Wow, that looks really difficult. A calculate in a calculate.
It works and thnx for that, but for me hard to understand.
Can I order or rank them? I tried adding 'ORDER BY [@Sum] DESC' but that doesn't work.
tamerj1
Community Champion
Community ChampionAnonymous
ORDER BY does not work in this case. Just sort the [@Sum] column