Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using MAX to filter for the current Fiscal week

The data set im working with tracks our internal fiscal week with "FWxx" format. I would like to set a dynamic filter for this data so that it always automatically filters for the highest number week...
Need Help
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Column:

    Fiscal Week = WEEKNUM([Date],2)

    Measure:

    Week Filter = 
IF (
    SELECTEDVALUE ( Query[Fiscal Week] )
        = CALCULATE (
            MAX ( Query[Fiscal Week] ),
            ALLEXCEPT ( Query, Query[Fiscal Week] )
        ),
    1,
    0
)

    In this case the view will show only the highest week. Does this meet your desired outcome?

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

 

You can try the following methods.

Column:

Fiscal Week = WEEKNUM([Date],2)

Measure:

Week Filter = 
IF (
    SELECTEDVALUE ( Query[Fiscal Week] )
        = CALCULATE (
            MAX ( Query[Fiscal Week] ),
            ALLEXCEPT ( Query, Query[Fiscal Week] )
        ),
    1,
    0
)

In this case the view will show only the highest week. Does this meet your desired outcome?

 

Best Regards,

Community Support Team _Charlotte

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