cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dsandip59 Member
Member

How to filter a column value using Calculate and FIlter function

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.
1 REPLY 1
Super User II
Super User II

Re: How to filter a column value using Calculate and FIlter function

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


MCSA: BI Reporting

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors