Forum Discussion

Kavelar1's avatar
Kavelar1
Frequent Visitor
1 year ago
Solved

T12 Flex-Flow Calculation

Hi again,   I am back with another issue. I am trying to display a T-12 based flex-flow calculation with a disconnected date on the x-axis for a bar chart. At the moment, when I apply my T12 filter...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

Your question is not clear.  Share some data, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

  • Kavelar1's avatar
    Kavelar1
    Frequent Visitor
    1 year ago

    Apologies. The top view is what it should look like but am using the main date table. The bottom view is what ends up appearing when placing the Disconnected T12 filter into the visual while plotting with the disconnected date table 'T12,2Y etc Purposes Dates.' The thing I am attempting to achieve is to allowing the user to select a year/month and see the flex-flow calculations for the last 12 months of the selected date as opposed to the most recent accesible data. 

     

     

    MonthRevenueGOP
    1/1/202395,79525,684
    2/1/202380,86030,215
    3/1/2023134,88644,039
    4/1/202386,26538,529
    5/1/2023117,19440,238
    6/1/2023124,13152,381
    7/1/2023140,26354,150
    8/1/202396,02332,657
    9/1/2023121,09030,593
    10/1/2023147,22164,547
    11/1/2023144,82052,520
    12/1/202380,76926,418
    1/1/2024139,73535,379
    2/1/2024142,95542,340
    3/1/2024144,92543,217
    4/1/2024147,96957,212
    5/1/202485,31131,735
    6/1/2024133,70755,707
    7/1/2024108,69330,941
    8/1/2024105,65834,678
    9/1/202498,43128,195
    10/1/202482,74733,187
    11/1/2024139,15046,619
    12/1/2024145,72542,491

     

     

     

    Flow (+) % vs Prior Year =
    VAR CurrentRevenue =
        CALCULATE(
            [Revenue],
            'Main Table'[Period] = "MTDCY"
        )

    VAR PriorRevenue =
        CALCULATE(
            [Revenue],
            'Main Table'[Period] = "MTDCY",
            SAMEPERIODLASTYEAR('Date'[Date])
        )

    VAR CurrentGOP =
        CALCULATE(
            [GOP],
            'Main Table'[Period] = "MTDCY"
        )

    VAR PriorGOP =
        CALCULATE(
            [GOP],
            'Main Table'[Period] = "MTDCY",
            SAMEPERIODLASTYEAR('Date'[Date])
        )

    VAR RevenueVariance = CurrentRevenue - PriorRevenue
    VAR GOPVariance = CurrentGOP - PriorGOP

    RETURN
    IF(
        RevenueVariance <= 0,
        BLANK(),
        DIVIDE(GOPVariance, RevenueVariance)
    )
     
     
    Thanks!