topic Dax help with date filter. in DAX Commands and Tips

Dax help with date filter.

DustinD — Thu, 10 Aug 2023 15:24:07 GMT

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.

Re: Dax help with date filter.

Anonymous — Mon, 14 Aug 2023 02:32:02 GMT

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