Display column and row values for max

[sigridr]

Hi, 

I have a dataset that looks something like this (just a lot bigger and with columns from 1 o'clock till 24). 

I know I can add a column for rowwise max values in query. But How do I then find the corresponding timestamp for that row? And how do I display it in a card or something like that in desktop? 

Thanks! 

Dato	Kl. 1	Kl. 2	Kl. 3	Kl. 4
01.01.2022	106,20	100,20	107,40	110,40
02.01.2022	114,60	114,00	111,60	103,80
03.01.2022	167,40	118,80	109,80	120,60
04.01.2022	136,80	120,60	120,00	123,60
05.01.2022	152,40	134,40	132,60	138,00
06.01.2022	150,00	130,80	131,40	152,40
07.01.2022	144,00	130,80	128,40	136,80

[sigridr · Accepted solution]

So I have an update: 

I used this: https://www.excelnaccess.com/finding-the-column-name-with-max-or-min-value/ 

And that worked fine. But if I have a data set like mine (i.e. dates instead of apples and oranges) - how do I get the max value to vary when I change my filters (between months) in desktop?

[sigridr]

Thanks! That worked! 🙂 

Sorry for the late reply..!

[sigridr · Accepted solution]

So I have an update: 

I used this: https://www.excelnaccess.com/finding-the-column-name-with-max-or-min-value/ 

And that worked fine. But if I have a data set like mine (i.e. dates instead of apples and oranges) - how do I get the max value to vary when I change my filters (between months) in desktop?

[Anonymous · Accepted solution]

Hi @sigridr ,

You can duplicate the table --> select [Kl. 1] to [Kl. 24] and unpivot the columns --> select [Dato] and Grouping -->  Merge Query --> Expand Columns.

Result:

Such data is well reflected in the change of maximum values by creating line charts in the desktop.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum