How to filter a column value using Calculate and FIlter function

[Anonymous]

Hi,

I am using below DAX to calculate a column value:

Measure 2 = Calculate(VALUES(Data[FILE_ID]), FILTEr(Data,

Data[Creation Date]>=Data[From Date] && Data[Creation Date]<=Data[To Date]))

so I want to find the file IDs based on the Creation Date using a DAX, but the above DAX does not

retun anything.

[edhans]

Can you provide some sample data, and also clarify what exactly you doing. Your title says calculated column, but you are using "measure 2" as the formula name, which is often something Power BI will create automatically when creating a measure, not a calculated column.