Forum Discussion
Creating a custom column to filter data
Hello. I have a very very large table being imported into my dataflow. i have a lot of columns, but for this post, i will shorten it with less columns Title | Category | Date A | E ...
Hello.
This gives me an error,
Expression.Error: The import IF matches no exports. Did you miss a module reference?
Details
Reason = Expression.Error
also what is the EDATE?
Use this DAX formula:
Status =
IF(
TableName[Category] = "Category B" && TableName[Date] < TODAY() - 730,
"Exclude",
"Include"
)
TODAY() - 730 dynamically calculates a 2-year range by subtracting 730 days from today’s date.
You can then filter your data based on the "Exclude" or "Include" status in the newly created column.