Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need guidance

Hello all ,    Please give me some guidence on how to get previous year month dates. i have a date table with Rank like  below      If I select 12/3/2022, the result should be rank 1    ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    Please refer to my pbix file.

    Measure =
VAR _1 =
    SELECTEDVALUE ( data[Date] )
VAR _format =
    FORMAT ( _1, "MMM" )
VAR _YEAR =
    YEAR ( _1 )
RETURN
    IF (
        _1 = SELECTEDVALUE ( 'Table'[Date] ),
        1,
        IF (
            _format = SELECTEDVALUE ( 'Table'[ Month] )
                && _YEAR <> SELECTEDVALUE ( 'Table'[year_colun] ),
            1
        )
    )

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

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

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

I do not understand your filter logic. Do you want to compare your current seleted month with the privious year (same month)?
Also I need some data example no screenshot. If rank is calculated also the DAX definition. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    andhiii079845 

    The goal is compare current year Date with previous year  Date (not Month vs Month)

    As the dates are not consistent , I added rank (this is optional ) 
    Here is the test DATA.     The eamples were added in my first request.

    Date Month YearRank
    8/14/2021AugAug-211
    8/28/2021AugAug-212
    8/20/2022AugAug-221
    12/5/2020DecDec-201
    12/4/2021DecDec-211
    12/3/2022DecDec-221
    12/31/2022DecDec-222