Latest date for each month in a bar graph

[zmukadam]

Hi,

I have to create a bar graph which shows the latest date for each month, I have currently created the chart with selecting the latest date but I would like this to happen automatically, is there a way of creating this?

Any help would be great.

[Ashish_Mathur · Accepted solution]

Hi,

In the picture, you will see the source data and the actual result.  You may download my PBI file from here.

Hope this helps.

[v-shex-msft]

HI @zmukadam ,

In my opinion, I'd like to suggest you to add a measure to compare current date and corresponded last date and return flag. After these, you can use this measure as filter on visual level.

Measure =
VAR currDate =
    MAX ( 'Table'[Date] )
VAR _lastdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            YEAR ( 'Table'[Date] ) = YEAR ( currDate )
                && MONTH ( 'Table'[Date] ) = MONTH ( currDate )
        )
    )
RETURN
    IF ( currDate = _lastdate, "Y", "N" )

Regards,

Xiaoxin Sheng