Forum Discussion

Maria_Maria's avatar
Maria_Maria
Helper II
4 years ago

filter dates with measure

I have a data set with a date column, category, and sum. I need to show only the same date in every month as the date chosen, so that if a user chooses 12.08 then the visual shows  - 12.07 - 12.06...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Maria_Maria , Try one of the two

 

max_date_month = CALCULATE(max(table[date]), Filter(all(table), eomonth(table[date],0) = eomonth(max(table[date]),0) && table[category] = max(table[category]) ))

 

or


max_date_month = CALCULATE(max(table[date]), Filter(allselected(table), eomonth(table[date],0) = eomonth(max(table[date]),0) && table[category] = max(table[category]) ))

Maria_Maria's avatar
Maria_Maria
Helper II
4 years ago

Hi amitchandak 

Thank you, but it eliminates the initial functionality - to chose the same dates in every month. Now it returns only last dates of months which is not what I am after

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Maria_Maria , Sorry, seems like I did not get it correctly.

     


    Please share sample data and sample output in table format? Or a sample pbix after removing sensitive data.