Hi There,
I have 2 Tables. A Dates Table and a Table where all my data is held called Base_Pivot. There are a bunch of columns in the Base_Pivot Table but the main ones i need looking at for this query is the 'Workflow Step Number', 'Incoming On' and 'Started On' columns. The Incoming On and Started On are dates and the workflow step number is what the count will be based upon. At the moment, all i can get is a total count for work outstanding currently but not historically and any time i try, the line graph just gives a straight line regardless of the months and years shown and gives the number as of today (e.g. figure is showing 15,000). I need a historical trend measure that will allow me to see what that 15,000 count of workflow step numbers was last week, or last month or last year so i can get a trend going back if that total count increased or decreased etc. I have attached a snapshot of sample data below.
I would want to know at whatever point in time i select through a slicer or filter, that i would be able to see those pieces of work that were outstanding in that point in time. The dates Table has loads of different time periods like month, year, financial year etc but THEDATE is what can connect the two tables and what the measure should be based upon from the Dates Table.
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
