Forum Discussion

JamesMarquezDev's avatar
JamesMarquezDev
Frequent Visitor
5 years ago

Variable Date from Measure Not Working in Filter Function

Why does hardcoding a date in the filter function result in a correctly filtered table:     Filtered Table = FILTER ( table, table[date_column] >= DATE(2021,5,1) )       However, u...
m3tr01d's avatar
m3tr01d
Continued Contributor
5 years ago

JamesMarquezDev 
Your "Filtered_Table", is it a calculated table?

  • JamesMarquezDev's avatar
    JamesMarquezDev
    Frequent Visitor
    5 years ago

    I'm using the FILTER function, but I did also try the CALCULATETABLE function which resulted in the same effect. The logic of my code and expression works fine when the date is hard coded. It just seems as though when using a variable to find a particular date, Power BI is running the FILTER function before assigning the date to the variable. In a normal programming project, I would use some print functions to identify what exactly is occuring while the function is running. Unfortunately I can't troubleshoot this problem in Power BI.

    • m3tr01d's avatar
      m3tr01d
      Continued Contributor
      5 years ago

      No, you didn't understand my question. 
      This object :

      Is it a table that you have created in Power BI using the "New table" option?

       

      We will need more information about your calendar table (Whats the min and max range of this table). 
      Also, if you can provide us a pbix example file, this would help us investigate