Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Fiscal Month Filter...

Hi All,

I need to filter by Fiscal Month. So if the user selects or enters say 05 for the fiscal month it displays records for 05, 04, 03, 02, 01 or a range of values equal to and less than 05 for the fiscal month column. Not that the fiscal month is stored as text.

 

Many Thanks!!

Need Help

2 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Anonymous ,

     

    create a calculated column to generate a numeric column...

    Fiscal Month No = VALUE('Table'[Fiscal Month])

     ...or better use a date table.

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

     

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Anonymous ,


    is your problem solved?
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.