Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All,
Instead having the lowest discount in the whole column, I would like to have the lowest discount % in the year as well.
how anyone help with it?
Thanks!
Solved! Go to Solution.
Hi, @shayla
try below
column =
minx(
filter(
all(table),
table[year]= max(table[year])
),
'table'[discount%]
)
Thanks for reply! @Dangar33
when I put the formular below, it only gives the max discount% in 2023, but I need max/min for every year..
could you please rectify my formula?
Thanks!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
20 | |
19 | |
13 | |
12 |
User | Count |
---|---|
42 | |
27 | |
23 | |
22 | |
22 |