I have data in Power BI that is weekly submitted summarized data, we do not overwrite the summary data from the previous week, we keep adding the new week. I need to be able to show in a report only the latest summary data for a value in another column in the same table.
In attached image you can see a list of Event Names where each has a set of records. The dates are the Summary File date for each of the Summary Files that have been uploaded over time (weekly). I want to be able to see only the latest Summary File rows for each event. So I need the report to reflect only the rows highlighted in yellow.
My columns are:
EventName & SummaryDate
For each EventName return only the list of rows where SummaryDate is latest date.
Hope it's clear. Please specify what other information you need from me. Thank you.
Hello, I can build this you want in Power BI as i am an experienced Power BI developer with over 8 years in the field. Please check my pirtfolio to see my work. Thanks!
14 freelancers are bidding on average $23 for this job
Hi, I am an expert in Power BI and have completed 110+ Power BI. I can create the required DAX formula for you. please send me a message to discuss further. Thanks.
in report level filter select advance filter as top n as date and select 1 date. if would automatically filter the top date Everytime. let me know if it's clear to you
I am one of the top producers of dashboards in my organisation. I use a range of Dax functions to create measures and calculations for rich insights into your data. I offer excellent value for money.