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 tracking table called "test", i am trying to to display only the most recent values for each group in column “CD_Trading_Id” regarding the value of the max Date modified.
Solved! Go to Solution.
Hi @mabdelrahman76 ,
If you dont want to have constant value for Status , just remove the filter in measure, like:
Measure =
var _max=CALCULATE(MAX('Table'[Modified]),FILTER(ALLSELECTED('Table'),[CD_Trading_Id]=MAX('Table'[CD_Trading_Id])))
return IF(MAX('Table'[Modified])=_max,1,0)
It will work, please try.
Best Regards,
Eyelyn Qin
Hi @mabdelrahman76 ,
If you dont want to have constant value for Status , just remove the filter in measure, like:
Measure =
var _max=CALCULATE(MAX('Table'[Modified]),FILTER(ALLSELECTED('Table'),[CD_Trading_Id]=MAX('Table'[CD_Trading_Id])))
return IF(MAX('Table'[Modified])=_max,1,0)
It will work, please try.
Best Regards,
Eyelyn Qin
Hi @mabdelrahman76 ,
You could refer to this blog about How to provide sample data in the Power BI Forum
I have built some dummy data to test, please try to create a flag measure and then apply it to filter pane.
Measure =
var _max=CALCULATE(MAX('Table'[Modified]),FILTER(ALLSELECTED('Table'),[CD_Trading_Id]=MAX('Table'[CD_Trading_Id]) && [Status]="Closed Cases"))
return IF(MAX('Table'[Modified])=_max,1,0)
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-eqin-msft , thanks for the feedback, but i dont want to have constant value for Status column, also i would likw to achive to return one value per group column "CD_Trading_id" based on the last modified date of the date range selection. i modified the data as what is shows in the below screeshoot to have good example.
my goal is to be able to return the maxiumum the values based on the max modified date range for each group in the date range selection, in my example if no selection i will return the below values based on the max date for each group.
Hi @mabdelrahman76 ,
According to your description, it seems that you just need to apply filters , like "Status="Closed Cases".
Can you please share your pbix file after removing sensitive data or some dummy data to help us clarify your scenario?
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-eqin-msft , thanks for the responce, how can i share the BI repoort here.
what i would like to achive in simple words, that i have slicer with date batwwen, and i have group and each group has values overtime, i would like to see the most receent values and sum based on the date range selection.
Please let me know how can i share the BI report?
Thanks
Mohamed
There are several simple ways to calculate the last date in a range of values. You could use the MAX function, LASTDATE function, or the LASTNONBLANK function. Hope this helps!
@littlemojopuppy thanks for prompt reply, i know but i am still need to filter out non corresponding values from the matrix as what i explained in my screenshoot and the total value should be "1", therefore i am trying to find a solution to display the value for the max date in each group in my i.e. i should return "closed cases" in group "31", i might need to use differnt solution to create summerize table but the table's values need to be calculated dynamically based on date range selection from the slicer, please review my previous reply and advise?
Also, i am trying differnt another solution is to create summerize table based on the date range selection column "Modified" in the original table "Test" but unfortunatly when i modifiy the range date in the slicer still pickup the max date from the original table, is there anyway to get the new date range inside the summerize table?
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |