Forum Discussion

Ajithrjaa's avatar
Ajithrjaa
Frequent Visitor
2 years ago
Solved

Use Case Cenario

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
)

 

 



Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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!!

1 Reply

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    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!!