Forum Discussion

azlocal21's avatar
azlocal21
Frequent Visitor
4 years ago
Solved

Date Filtering Issues

Hello everyone! Super new, and mostly self taught in Power Bi Destkop. I have gotten a lot of help building measures from this forum but I have not been able to find the help I need for this issue...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    azlocal21 , Try a measure like

     


    var _max = VAR _MostRecentFilter = MAXX( Filter( allselected('Table1') , 'Table1'[Start_Date]<=Today()) ,'Table1'[Start_Date])
    Return
    calculate(count('Table1'[Start_Date]), filter('Table1', 'Table1'[Start_Date] =__max))

amitchandak's avatar
amitchandak
Super User
4 years ago

azlocal21 , Try a measure like

 


var _max = VAR _MostRecentFilter = MAXX( Filter( allselected('Table1') , 'Table1'[Start_Date]<=Today()) ,'Table1'[Start_Date])
Return
calculate(count('Table1'[Start_Date]), filter('Table1', 'Table1'[Start_Date] =__max))

azlocal21's avatar
azlocal21
Frequent Visitor
4 years ago

When I tried that this is the error message it gives me.

The syntax for ')' is incorrect. (DAX(var _max = VAR MostRecentFilter = MAXX( Filter( allselected('Table1') , 'Table1'[Start_Date]<=Today()) ,'Table11'[Start_Date])Returncalculate(count('Table1'[Start_Date]), filter('Table1', 'Table1'[Start_Date] =_max)))).


**Update**

I removed the VAR _MostRecentFilter from the measure and that works great for giving me the number or most recent hires for the most recent start date.

The problem I am having now is that the finish date is pulling the earliest date for every exam path.