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,
Regarding table with data below, I would like to ask:
how I could create report table, where I could pick specifick period of time (for example 1/14/2020-1/20/2020) and then pick the newest rows regarding "Group" name?
Project | Group | Group_status | Date |
Main | main_1gr | Passed | 1/11/2020 |
Main | main_1gr | Failed | 1/13/2020 |
Main | main_3gr | Failed | 1/14/2020 |
Main | main_2gr | Failed | 1/15/2020 |
Main | main_1gr | Failed | 1/16/2020 |
Main | main_1gr | Failed | 1/19/2020 |
Sys | sys_1gr | Failed | 1/11/2020 |
Sys | sys_2gr | Failed | 1/13/2020 |
Sys | sys_1gr | Passed | 1/14/2020 |
Sys | sys_2gr | Failed | 1/15/2020 |
Sys | sys_2gr | Failed | 1/17/2020 |
v104 | v104_1gr | Failed | 1/14/2020 |
V104 | v104_1gr | Passed | 1/17/2020 |
v104 | v104_1gr | Failed | 1/18/2020 |
v20 | v20_1gr | Failed | 1/14/2020 |
v20 | v20_1gr | Passed | 1/20/2020 |
v20 | v20_1gr | Failed | 1/21/2020 |
v20 | v20_1gr | Failed | 1/22/2020 |
Solved! Go to Solution.
Not really good at DAX but make a measure then that will serve as your table filter.
Not really good at DAX but make a measure then that will serve as your table filter.
Thank you, @dustinn , your measure helped me! Only, I replaced 'Table'[Group] to 'Table'[Project].
create a measure like this and use in your visual
calculate(countrow(table),
filter(summarize(table,table[Group],"_maxdt",max(table[date]),"_maxGp",max(table[Group])),
table[Group]=[_maxGp] && max(table[date]=_maxdt)))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |