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 m...
  • 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

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