Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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?
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
Thanks! That worked! 🙂
Sorry for the late reply..!
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 @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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.