Comparing current month to first month in year

[20pence]

Hello,

Looking for some expert help.

I have data from every month of the year, each month has a 'total estate' number. I would like to (using the KPI card) show the current selected months total estate and in the target show the first month of the years total estate. I've seen many posts on current vs previous month but can't see any solutions to this.

Thank you in advance 🙂 

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Selected monthyear value: = 
SUM( Data[Value] )

Selected year's january value: =
VAR _selectedyear =
    YEAR ( MAX ( 'Calendar'[Date] ) )
RETURN
    CALCULATE (
        [Selected monthyear value:],
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[Year] = _selectedyear
                && MONTH ( 'Calendar'[Date] ) = 1
        )
    )

[Jayee]

Hi @20pence 

Suppose you have a column with number for each month in calendar table so 1 is the first month Jan in this case use the below measure and i am assuming that you have a year slicer for single selection

Measure = Calculate ( Sum(Value), monthnumber=1)

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!