Forum Discussion

DustinD's avatar
DustinD
Icon for Helper I rankHelper I
3 years ago
Solved

Dax help with date filter.

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's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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