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.
Hello Community,
I would appreciated it if you could help me with the below question.
I have the below table that has shows the benefits details per year of three projects.
What I want to create is a table that shows the minimum and maximum year per project, based on the non blank values of all three benefit columns.
Input table
Project | Year | Benefit1 | Benefit2 | Benefit3 |
Project1 | 2019 | 435 | 311 | |
Project1 | 2020 | 133 | 200 | 141 |
Project1 | 2021 | 281 | 380 | |
Project1 | 2022 | |||
Project2 | 2019 | 367 | ||
Project2 | 2020 | 298 | 248 | 262 |
Project2 | 2021 | 255 | 305 | 348 |
Project2 | 2022 | 203 | ||
Project3 | 2019 | |||
Project3 | 2020 | 462 | 467 | 491 |
Project3 | 2021 | 440 | 478 | |
Project3 | 2022 | 470 |
Output table
Project | MinYear | MaxYear |
Project1 | 2019 | 2021 |
Project2 | 2019 | 2022 |
Project3 | 2020 | 2022 |
Thank you in advance,
George
Solved! Go to Solution.
@Anonymous , Try 2 measures like
Min year =
minx(filter(Table, not(isblank(Table[Benefit1])) || not(isblank(Table[Benefit2])) || not(isblank(Table[Benefit3]))), Table[Year])
max year =
maxx(filter(Table, not(isblank(Table[Benefit1])) || not(isblank(Table[Benefit2])) || not(isblank(Table[Benefit3]))), Table[Year])
@Anonymous , Try 2 measures like
Min year =
minx(filter(Table, not(isblank(Table[Benefit1])) || not(isblank(Table[Benefit2])) || not(isblank(Table[Benefit3]))), Table[Year])
max year =
maxx(filter(Table, not(isblank(Table[Benefit1])) || not(isblank(Table[Benefit2])) || not(isblank(Table[Benefit3]))), Table[Year])
Hello @amitchandak
Your solution worked just fine. Thank you very much for that.
I tried to give you a Kudos and flag your reply as a solution, only to come across the below error.
"Authentication failed for the action you are trying to do. This failure could be due to your browser not supporting JavaScript, JavaScript not being enabled, or trying to use the action URL directly in the browser address bar instead of clicking the link on the page. "
Would you have any idea how this can be sorted out?
I also sent you a LinkedIn request, would be glad if you would accept it.
Kind regards,
George
@Anonymous , Accepted your LinkedIn connection.
Just refresh and check if you still logged in. If not log in again and try.
Hi @amitchandak ,
I just gave it another try to flag your input as solution without any success.
Can you please flag it as such?
Kind regards,
George
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.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |