The sales plan on the card is not displayed if the slice is not set on the first day of the month.

[Sergii22]

Please help me understand:
I have a standard sales plan table. The date column displays only the first days of each of the 12 months. I display the budget amount on a card and create a slice by the date column, which is formed as DateTable = CALENDARAUTO(12).
When I specify a time interval in the slice that includes the first of the month, I get the budget amount. As soon as I set an intermediate date, for example 01/02/2023 - 01/20/2023, the budget data disappears. It is necessary for me, that the budget of month or months falling in the interval of time chosen by me was deduced.
I will be grateful for your help!

[Anonymous]

Hi  @Sergii22 ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Date =
DISTINCT('Table'[Date])

2. Create measure.

Measure =
var _mindate=MINX(ALLSELECTED('Date'),[Date])
var _maxdate=MAXX(ALLSELECTED('Date'),[Date])
var _select=
SELECTCOLUMNS(
    FILTER(ALL('Table'),'Table'[Date]>=_mindate&&'Table'[Date]<=_maxdate),"Month",MONTH('Table'[Date]))
return
SUMX(FILTER(ALL('Table'),
MONTH('Table'[Date]) in _select),[Value])

3. Result:

Best Regards,

Liu Yang

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

[Sergii22]

Greetings! Thanks for the answer, but my problem is not solved.  I need the values to be displayed when selecting a range within the month as well. For example, if I select January 2 - January 20, the values will not be displayed on the card.

[amitchandak]

@Sergii22 , that depends on what measure you are using.

In case you use dates* or previous* functions

Why DATESMTD is still blank, even after having correct TI Setup: https://youtu.be/j0ug-XQgZtg

openingbalancemonth, openingbalancequarter, openingbalanceyear: https://youtu.be/6lzYOXI5wfo

Power BI Allocating Targets- closingbalancemonth, closingbalancequarter, closingbalanceyear:https://youtu.be/yPQ9UV37LOU