Forum Discussion
CADACAMA
Microsoft Employee
Microsoft EmployeeHelp 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 ...
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
)
)
Ashish_Mathur
Super User
Super UserHi,
I think we should solve this with a measure. Based on the third table that you have selected, show the expected result.