Use Case Cenario

[Ajithrjaa]

Hi All, I have some use case cenario.

Link : https://drive.google.com/file/d/1BKuC0jXpJcEXxG0sse-3lY0RbHEsqfc2/view?usp=sharing

I have table Visual Contains a Columns Fiscal Year, Net Fees, Rank (Rank I have created Based on Month Number)
If my current Fiscal Year Max Month Number is 2 then I wold Like to see Remaing Month <=2 FY2024 and FY2023.

If my current Fiscal Year Max Month Number is 3 then I wold Like to see Remaing Month <=3 FY2024 and FY2023 I dont want Remaing Month Data.

expected Out put like

Column = if('Table'[Rank] <= MAX('Table'[Rank]), 1,0)

max =

  CALCULATE(

    MAX('Table'[Rank]),

    ALL('Table'[Fiscal Year])  // Replace 'Date' with your actual date table name

)

[rajendraongole1 · Accepted solution]

Hi @Ajithrjaa - create a below measure for max month number and add it to the table chart.

MaxMonthNumber =

CALCULATE(

    MAX('Table'[Rank]),

    FILTER('Table', 'Table'[Fiscal Year] = MAX('Table'[Fiscal Year]))

)

created calculated column as below for filter applied

IsVisible =

IF(

    'Table'[Rank] <=

        CALCULATE(

            MAX('Table'[Rank]),

            FILTER('Table', 'Table'[Fiscal Year] = MAX('Table'[Fiscal Year]))

        ),

    1,

    0

)

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!