Date Range with Date Slicer

[Vinutha]

Hello Power BI Experts,

I am currently working on defining a dashboard for which all the metric calculations are based on the Summaries(Date Range,Type-Monthly,Weekly,Yearly ) , Location and Department.

To start of with i started with the Date Range 

I created a Date table ,joined to the main table.Then in the main table i created a measure(indate Range) and dashboardcount. The count i see is more than what i see it manually

DATE TABLE SYNTAX:

Date =

CALENDAR(

    MIN('sheet'[start]),

    MAX('sheet'[end])

)

 

RECORD_ID	START_DATE	END_DATE
16687339	1/15/24 8:50 PM	1/17/24 7:11 PM
16709054	1/22/24 10:03 AM	1/27/24 8:56 PM
16649877	1/5/24 6:03 AM	1/6/24 5:32 PM
16707403	1/21/24 2:38 PM	1/24/24 5:13 PM
16732660	1/28/24 3:06 AM	1/31/24 6:13 PM
16685134	1/14/24 8:16 PM	1/16/24 6:55 PM
16635276	1/1/24 3:24 PM	1/3/24 11:04 AM
16733788	1/28/24 3:54 PM	1/29/24 6:00 PM
16653543	1/5/24 10:33 PM	1/6/24 11:04 AM
16635584	1/1/24 5:40 PM	1/3/24 3:39 PM
16692579	1/17/24 12:24 PM	1/17/24 9:05 PM
16700030	1/18/24 10:53 PM	1/19/24 4:25 PM
16674920	1/11/24 3:59 PM	1/13/24 9:02 PM
16681518	1/13/24 8:07 AM	1/19/24 8:40 PM
16724261	1/25/24 4:22 PM	1/27/24 10:54 AM
16634884	1/1/24 1:03 PM	1/17/24 12:19 PM
16682816	1/13/24 6:26 PM	1/14/24 6:48 PM
16703587	1/19/24 10:21 PM	1/20/24 1:43 PM
16679834	1/12/24 4:57 PM	1/12/24 11:14 PM
16730758	1/27/24 9:51 AM	1/29/24 8:00 PM
16685585	1/15/24 3:58 AM	1/19/24 6:52 PM
16695821	1/18/24 8:52 AM	1/19/24 6:56 PM
16685086	1/14/24 7:46 PM	1/15/24 3:20 PM
16737786	1/29/24 5:45 PM	1/31/24 9:19 PM
16653049	1/5/24 6:52 PM	1/7/24 11:50 AM
16725374	1/26/24 1:15 AM	1/30/24 6:39 PM
16664687	1/7/24 10:36 PM	1/9/24 6:00 AM

InDateRange =

VAR _rangeStart = MIN('Date'[Date])

VAR _rangeEnd = MAX('Date'[Date])

RETURN

IF (

    MAX('sheet'[start]) <= _rangeEnd &&

    MAX('sheet'[end]) >= _rangeStart,

    1,

    0

)

dashboardcount =

CALCULATE (

    COUNTROWS('sheet'),

    FILTER(

        'sheet',

        [InDateRange] = 1

    )

)

[Vinutha]

dashboardcount =    COUNTROWS('PULSE DATA') Trying to get the count  and linked to the date range 

[lbendlin]

Calendar tables have Date columns that are actually DateTime type values pegged at midnight.  You will have to define what "Range"  means for you.  Is 1/15/24 8:50 PM counting as 1/15/24 or 1/16/24 ?  Or do you need the fractions too?

What is the expected outcome based on your sample data?

[Vinutha · Accepted solution]

As you mentioned i changed the date format to exclude the time stamp by "many to one" and "both" and it worked. Thanks much for the lead.

[Vinutha]

Hello lbendlin,

Thank you so much for getting back to me. The expected outcome is count of the dashboard

[lbendlin]

What is the expected outcome based on your sample data?