The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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
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.