Dax help with date filter.

[DustinD]

i have made a example of what my data looks like in the screen shot below. what im trying to acomplish is get it so the corespoding remsales only show on there import date. for example the month of may should only show the rows i have highlighted and the rest in the coulmn should be blank. i have also included my dax that i was trying to get to work but was unable to do. any help is appreciated. thanks.

          

[Anonymous · Accepted solution]

Hi  @DustinD ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _select=SELECTEDVALUE('Table 2'[Date].[Month])
return
IF(
FORMAT(MAX('Table'[Month  ImportDate]),"mmmm")=_select,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly