Forum Discussion

Microsoft Employee

9 months ago

Solved

Help with filtering table and using that table as context

I realize that my subject is a bit vague so let me start with a practical example. I have the following data: 1 10/1/2025 2 10/10/2025 3 10/11/2025 4 10/12/2025 and I want to ...

Need Help

Kedar_Pande
9 months ago
Create a calculated column:

Burndown Count =
VAR CurrentDate = 'table'[Changed Date]
VAR FilteredTable = FILTER(ALL('table'), 'table'[Is Current] = TRUE())
RETURN
COUNTROWS(
FILTER(
FilteredTable,
'table'[Changed Date] >= DATE(2025, 10, 9) &&
'table'[Changed Date] <= CurrentDate
)
)

CADACAMA

CADACAMA

Microsoft Employee

9 months ago

This is a real sample of the data:

1	10/1/2025	True
2	10/10/2025	False
2	10/10/2025	True
3	10/11/2025	True
4	10/12/2025	True

After we filter out the 'False' entries I expect the following table:

1	10/1/2025	True
2	10/10/2025	True
3	10/11/2025	True
4	10/12/2025	True

Then after applying the date accumulation (based on dates after 10/9/2025) I expect the following table (with a newly added column):

1	10/1/2025	True	0
2	10/10/2025	True	1
3	10/11/2025	True	2
4	10/12/2025	True	3

Keep in mind, that last generated column is based on the filtered table. The value calculated there is equivalent to saying something like: "count all dates prior to this date but after 10/9/2025".