Value of selected minimum and maximum date

[MHTANK]

This is my Data:

This is my report:

These are my calculations:

Max_Date_ = MAX('Sheet1 (2)'[Date])

Max_Date_Avg_ = CALCULATE(AVERAGE('Sheet1 (2)'[Value]), 'Sheet1 (2)'[Date] = MAX('Sheet1 (2)'[Date]))

Min_Date_ = MIN('Sheet1 (2)'[Date])

Min_Date_Avg_ = CALCULATE(AVERAGE('Sheet1 (2)'[Value]),  'Sheet1 (2)'[Date] = MIN('Sheet1 (2)'[Date]))

In the report when I select two date from slicer there is no value for "A" category of date "24-January-2023" then why value comes "12.00" in table. There I want blank.

[MHTANK]

My problem is solved. Thank you very much @v-weiyan1-msft  and all

[v-weiyan1-msft · Accepted solution]

Hi @MHTANK ,

Based on the sample and description you provided, Please try the following steps:
1.You can create a Calculated table.

DateTable = VALUES('Table'[Date])

There is no relationship between the two tables.

2. Use the following code to create Measure.

Min_Date_ = MIN('DateTable'[Date])

Min_Date_Avg_ = 
CALCULATE (
    AVERAGE ( 'Table'[Value] ),
    FILTER ( 'Table', 'Table'[Date] = [Min_Date_] )
)

Max_Date_ = MAX('DateTable'[Date])

Max_Date_Avg_ = 
CALCULATE (
    AVERAGE ( 'Table'[Value] ),
    FILTER ( 'Table', 'Table'[Date] = [Max_Date_] )
)

The field of the slicer is from DateTable. When you select "1/24/2023", "1/30/2023" in the slicer, Result is as below.

For further details，please find attachment.

Best Regards,
Yulia Yan

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

[MHTANK]

When I select "21-Jan-2023" to "31-Jan-2023" then in category "B", there is no value in Data for "21-Jan" , then why come "4.00"?

[MHTANK]

No, this is not work, same problem again.

[PijushRoy]

Hi @MHTANK 

If you bring directly Date column from your table into Slicer
Set the Slicer Seeting as Between
What is the issue you are facing?

[PijushRoy]

Hi @MHTANK 

Why you are not using Old Slicer with Between Date Range with Slider

.

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin