Forum Discussion

GWTF's avatar
GWTF
Helper I
4 years ago
Solved

Comparing rolling years....?

Hi all, Yeah, even a good subject decription was hard...   I'm running into the boundaries of my limited Power BI capabilities 😁 AKA: I need help!!   I'm trying to create a measure that gives m...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi GWTF ,

     

    You could refer below formulas.

    _YTD =
CALCULATE (
    SUM ( Incidents_table[amount] ),
    FILTER (
        ALLSELECTED ( Incidents_table ),
        Incidents_table[Incident_date]
            > EDATE ( SELECTEDVALUE ( Incidents_table[Incident_date] ), -12 )
            && Incidents_table[Incident_date]
                <= SELECTEDVALUE ( Incidents_table[Incident_date] )
    )
)

    P_YTD =
CALCULATE (
    SUM ( Incidents_table[amount] ),
    FILTER (
        ALLSELECTED ( Incidents_table ),
        Incidents_table[Incident_date]
            > EDATE ( SELECTEDVALUE ( Incidents_table[Incident_date] ), -24 )
            && Incidents_table[Incident_date]
                <= EDATE ( SELECTEDVALUE ( Incidents_table[Incident_date] ), -12 )
    )
)

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi GWTF ,

 

You could refer below formulas.

_YTD =
CALCULATE (
    SUM ( Incidents_table[amount] ),
    FILTER (
        ALLSELECTED ( Incidents_table ),
        Incidents_table[Incident_date]
            > EDATE ( SELECTEDVALUE ( Incidents_table[Incident_date] ), -12 )
            && Incidents_table[Incident_date]
                <= SELECTEDVALUE ( Incidents_table[Incident_date] )
    )
)

P_YTD =
CALCULATE (
    SUM ( Incidents_table[amount] ),
    FILTER (
        ALLSELECTED ( Incidents_table ),
        Incidents_table[Incident_date]
            > EDATE ( SELECTEDVALUE ( Incidents_table[Incident_date] ), -24 )
            && Incidents_table[Incident_date]
                <= EDATE ( SELECTEDVALUE ( Incidents_table[Incident_date] ), -12 )
    )
)

 

Best Regards,

Jay