Forum Discussion
Display column and row values for max
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 |
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?
Hi Anonymous ,
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 TeamIf 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
3 Replies
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?
Hi Anonymous ,
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 TeamIf 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