Dual Slicing

Hello, I have a request and I'm not sure if it is possible, but my company currently is running an older version of PBI (2022) at the moment (looking to upgrade shortly), but they want a report ...

Need Help

Tips and Tricks

Tutorial Requests

Anonymous

1 year ago

Hi ianallen13V2 ,

Maybe you can try formula like below:

Current= 
VAR sel_year =
    SELECTEDVALUE ( 'Date'[Year] )
VAR sel_month =
    SELECTEDVALUE ( 'Date'[Month] )
RETURN
    IF (
        ISFILTERED ( 'Table' ),
        CALCULATE (
            SUM ( 'Table'[Sales] ),
            FILTER (
                ALL('Table'),
                YEAR ( 'Table'[Date] ) = sel_year
                    && MONTH ( 'Table'[Month] ) = sel_month
            )
        ),        CALCULATE (
            SUM ( 'Table'[Sales] ),
            FILTER (
                ALL('Table'),
                YEAR ( [Date] ) = YEAR ( TODAY () )
                    && MONTH ( [Date] ) = MONTH ( TODAY () )
            )
        )
    )

Previous= 
VAR sel_year =
    SELECTEDVALUE ( 'Date'[Year] )
VAR sel_month =
    SELECTEDVALUE ( 'Date'[Month] )
RETURN
    IF (
        ISFILTERED ( 'Table' ),
        CALCULATE (
            SUM ( 'Table'[Sales] ),
            FILTER (
                ALL('Table'),
                YEAR ( 'Table'[Date] ) = sel_year
                    && MONTH ( 'Table'[Month] ) = sel_month
            )
        ),        CALCULATE (
            SUM ( 'Table'[Sales] ),
            FILTER (
                ALL('Table'),
                YEAR ( [Date] ) = YEAR ( TODAY () ) - 1
                    && MONTH ( [Date] ) = MONTH ( TODAY () )
            )
        )
    )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Dual Slicing

Related content

Dual Storage mode

Dual sided table

Dual Sorting for Stacked Bar Chart

Power BI dual Storgae Mode question

Dual Y axis overlapping column chart