Forum Discussion

balu810's avatar
balu810
Advocate I
3 years ago
Solved

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 2021...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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]
    )

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

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]
    )