cancel
Showing results for
Did you mean:
Frequent Visitor

## Dynamic YTD calculation

I have data in below format , user wants single select slicer on Yearquarter , when he select 202202 , we have to show him two bars one for year 2021 and one for year 2022 . 2021 bar should show 202101,202102 value and 2022 bar should show 2022101 , 202202 value as a sum

2021-300

2022-150

when user selects 202203 it should show all three quarters of 2022 and first three quarters of 2021.

 Yearquarter Year Quarter Sales 202101 2021 01 100 202102 2021 02 200 202103 2021 03 300 202104 2021 04 400 202201 2022 01 120 202202 2022 02 130 202203 2022 03 140
1 ACCEPTED SOLUTION
Super User

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

``````expected result measure: =
VAR _sliceryear =
MAX ( 'Calendar'[Year] )
VAR _prevsliceryear = _sliceryear - 1
VAR _slicerquarter =
MAX ( 'Calendar'[Quarter] )
RETURN
SUMX (
FILTER (
Data,
Data[Year]
IN { _sliceryear, _prevsliceryear }
&& Data[Quarter] <= _slicerquarter
),
Data[Sales]
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

2 REPLIES 2
Super User

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

``````expected result measure: =
VAR _sliceryear =
MAX ( 'Calendar'[Year] )
VAR _prevsliceryear = _sliceryear - 1
VAR _slicerquarter =
MAX ( 'Calendar'[Quarter] )
RETURN
SUMX (
FILTER (
Data,
Data[Year]
IN { _sliceryear, _prevsliceryear }
&& Data[Quarter] <= _slicerquarter
),
Data[Sales]
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Frequent Visitor

Announcements

#### Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

#### Power BI May 2023 Update

Find out more about the May 2023 update.