Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Get latest data as per week end date to create stacked

Hi All,

 

I am new to the community and I went through the forum and couldn't find the solution so posting a new question.

I have the attached the pbix file with the required input and output.

 

Basically i want the latest high level status as per week end date. 
For E.g if an id is shown as open in the week ending 3rd Feb but closed in W/E 10th Feb then for 3rd Feb week the id should be counted as Open but for 10th Feb it should be counted under Closed.

 

I will be using this data to create a stacked chart to show the progress by week.
Power BI File 

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous,

It seems like a common multiple date range analysis requirements, I'd like to suggest you take a look at the following blog 'start date', 'end date' part if it helps:

Before You Post, Read This - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

Anonymous
Not applicable

Thanks @Anonymous, really appreciate the help.

I had a look at the blog you mentioned but was not able to relate to my situation.
Below is what i am trying to achieve:
Group by ids with latest status shown based of the week end date
For e.g. if in week one the latest status for id 1001 is Open then it should show Open for that week end but the same id changes to in progress in week 2 then it should show In Progress and so on..

I can get the latest status using grouping in power query but not sure how to get the latest status as of week end dates.
In my mind i am thinking some Dax or M-query which will give results as group data for all dates lessthan or equal to every weekend date, something like running total giving latest status.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.