How to get a range of months' separate values

[oneMills33]

I have four measures originated from each different table and these tables are related with one calendar table.

I want to get values of each months from those measures in specific range selected by the month from the calendar table.

The range should be like this;

If I choose Febuary 2024, the range should be January 2024 ~ March 2024.

If I choose August 2024, the range should be January 2024 ~ September 2024.

So it's basically, [Start of Year] to [Next Month].

I fulfilled this by making a calculated table, but since there is some capacity issue, I want to try it with just measures.

The ideal visual should be like the first table visual which was made by the calculated table,
but I can only get chosen month and each range's totals with measures like the below one.


the daxes I tried in measures are like these :
VAR Result =
CALCULATE(
Calculation
,ALL(v_dim_calendar),
v_dim_calendar[date]>=DATE(SELECTEDVALUE(v_dim_calendar[year]),1,1),
v_dim_calendar[date]<=EOMONTH(MAX(v_dim_calendar[date]),1))

RETURN
Result

and,

VAR Result =
CALCULATE(
Calculation
,DATESBETWEEN(v_dim_calendar[date],STARTOFYEAR(v_dim_calendar[date]),EOMONTH(MAX(v_dim_calendar[date]),1)))

RETURN
Result

Any help would be so thankful.

[Anonymous · Accepted solution]

Hi @oneMills33 

Unfortunaltely, it's not support for power bi to implement this function.

Maybe you can try bookmark:

First of all, I create a set of sample:

Then create a slicer, for example:

Then add a bookmark in the view, and rename it:

Insert > buttons

Format > Action > Bookmark

Style > Text 

The result is as follow:

^{Best Regards,}

^{Zhengdong Xu}

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

[oneMills33]

thank you so much for the suggestion but unfortunately the calendar range is so vast book marking is quite impossible rn. but i appreciate for assuring that the problem is not solvable finally lmao!