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?
Hi PPStar ,
Check to make sure you are copying the dax code provided by Kedar_Pande correctly, it should work fine.'' Edate' function works better for your needs, if you simply use 'Today - 720', you may get an error because leap year has 366 days.
Column = IF([_category] = "B" && [Date] < EDATE(TODAY(),-24) ,"exclude","include")
Best Regards,
Wenbin Zhou