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.
Solved! Go to Solution.
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" )