Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date Filtering

Hi Power Bi Community,    I want to create a slicer which gives an option to choose the month in 2022 and the outcome in the table should show the ongoing job in that chosen month. For example, if ...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    3 years ago

    Hi Anonymous ,

     

    You can try formula like below:

    M =
VAR min_ =
    MONTH ( MIN ( 'Table'[Start] ) )
VAR max_ =
    MONTH ( MIN ( 'Table'[End] ) )
VAR sel_month =
    MONTH ( SELECTEDVALUE ( 'Table 2'[Date] ) )
RETURN
    IF ( sel_month < max_ && sel_month >= min_, 1, 0 )

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

Hi Anonymous ,

 

You can try formula like below:

M =
VAR min_ =
    MONTH ( MIN ( 'Table'[Start] ) )
VAR max_ =
    MONTH ( MIN ( 'Table'[End] ) )
VAR sel_month =
    MONTH ( SELECTEDVALUE ( 'Table 2'[Date] ) )
RETURN
    IF ( sel_month < max_ && sel_month >= min_, 1, 0 )

 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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