Forum Discussion

wg's avatar
wg
Regular Visitor
8 years ago
Solved

DAX Top and Bottom Calculations Across a Row

Hello everyone,     I am working on a project where the data coming in is spread across multiple columns (see image below).   The problem that I have is that I need to rank the months acro...
wg's avatar
wg
Regular Visitor
8 years ago

Thank you, Anonymous

 

It looks like you did was I was debating about doing - pivoting the data to then rank. I really appreciate the response, as this gave me exactly what I needed.

 

I created a pivoted table based on the data as it exists in the current data table, used the formulas you shared with me in your sample file, and then joined the two tables together to allow filtering to work seamlessly.

 

Thanks again!