Task Report (graph)

[Ad112]

*tables structured down

Breaking my brain to create for a user stacked column bar:

every Saturday snapshot of the current situation is saved on Task_Weekly table, so can be multiplied rows with the same task id, with same/different state but with the different current date (7 days jumps).

Example via PowerPoint 

about the Closed Tasks

• if task closed last saterday (10.6.23) and today iam on weekly\bi weekly\montly - i want to count this task as closed even 2 weeks ago he was new.
• if task closed two weeks ago(3.6.23) and this saterday this task still closed and have new row at Task_Weekly table with 10.6.23 current date - so when i look weekly timeframe i dont want to count this task as closed, but if i look bi-weekly i want to count it.

Tables Structures:

Fact_Task_Vw:

Task ID (Primary Key)

Assigned To User

Time In State (Days)

Tasks_Weekly: (Task ID + CurrentDate = unique value)

Task ID (Foreign Key referencing Fact_Task_Vw)

Current Date (Snapshot date)

State

CurrDate_Cal_Vw:

Current Date(Referencing Tasks_Weekly)

YearShow

if its dax tip and tricks please move my post.

Thank

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...