MAX VALUE vs END OF MONTH VALUE (for each month) group bar chart, based on a MEASURE

[MatiasDamian]

Hi guys! I've posted another question without registrating and cant find it so here I go again.

I have 2 tables, 1 with my Dates calendar and 2 with my data (including my MEASURE which accumulate certaing Sum).

I need to create something like this chart (which compares MAX value VS END OF MONTH value, for each month): 
https://i.stack.imgur.com/kP2cH.png (I leave the link because this wont let me post the image, sorry!)


And it it would be a table I imagine it like this:

DATE	-MEASURE	-MAX MONTH MEASURE	-END OF MONTH MEASURE
01/01/2021	5000	6000	5300
02/01/2021	5500	6000	5300
03/01/2021	6000	6000	5300
n…
31/01/2021	5300	6000	5300
01/02/2021	5700	6800	6100
02/02/2021	6200	6800	6100
03/02/2021	6800	6800	6100
28/02/2021	6100	6800	6100
01/03/2021	4200	9000	9000
02/03/2021	4900	9000	9000
03/03/2021	7800	9000	9000
31/03/2021	9000	9000	9000

I've tried a lot of things but couldnt reach it. Would you please help?

Thanks and regards!

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[MatiasDamian]

Hi @Ashish_Mathur  thanks a lot but since its a company server and workbooks are restricted for internal employees, I dont know how to publish in order you to see it. Could you please guide me if there's some kind of "packaged" workbook like in Tableau?

Thanks again!

[amitchandak · Accepted solution]

@MatiasDamian , Try measures like

Max = CALCULATE(maxx(values('Date'[Date]),[MEASURE]),DATESMTD(ENDOFMONTH('Date'[Date])))

Last value = CLOSINGBALANCEMONTH([MEASURE],'Date'[Date])

[MatiasDamian]

Hi @amitchandak , you're awesome dude! This solves my question, the only matter is that it messes with my original measure which accumulates some IN-OUT differences and now its displaying non-sense. But anyway, your answer was the solution, I'll have to work with different ways to develop my measure.

Thanks a lot!!!

Matias