topic Need to create a visual that displays data from the current day and the from three historical days in DAX Commands and Tips

Need to create a visual that displays data from the current day and the from three historical days

Anonymous — Tue, 13 Oct 2020 21:07:04 GMT

Help,

I am trying to display Contact Center data on a visual, preferably a bar graph of clustered bar graph. The fields contain DateTime and CallsHandled. What I would like to display is the data for Today's Date and times (interval) and then the historical data from the previous 3 days with the same DOW. For example, display Today's datetimes of 10/13/2020 07:00:00 AM... 10/13/2020 06:00:00 PM, 10/6/2020 07:00:00 AM... 10/6/2020 06:00:00 PM, 09/29/2020 07:00:00 AM... 09/29/2020 06:00:00 PM and 09/22/2020 07:00:00 AM... 09/22/2020 06:00:00 PM.

The data is in one table and contains 6 months of historical data.

Any help with this would be greatly appreciated.

Mark

Re: Need to create a visual that displays data from the current day and the from three historical days

wdx223_Daniel — Wed, 14 Oct 2020 03:39:53 GMT

TTL_Display = VAR _CurrenctDate = TODAY () VAR _CurrenctWeekDay = WEEKDAY ( _CurrenctDate ) VAR DaysSelected = TOPN ( 3, FILTER ( ALL ( ContactData[Date] ), WEEKDAY ( ContactData[Date] ) = _CurrenctWeekDay && ContactData[Date] <= _CurrenctDate ), ContactData[Date] ) RETURN CALCULATE ( [TTL], KEEPFILTERS ( ContactData[Date] IN DaysSelected ) )

hope this can help you!!

Re: Need to create a visual that displays data from the current day and the from three historical days

Anonymous — Thu, 15 Oct 2020 12:35:43 GMT

Thanks for your response...

I am taking a look at the measure you sent and have a newbe question. What is TTL in the calculate?

I set it up to use my data and ran into this question.

Thanks... Mark

Re: Need to create a visual that displays data from the current day and the from three historical days

wdx223_Daniel — Fri, 16 Oct 2020 00:24:53 GMT

the code of TTL measure is =SUM(ContactData[CallsHandled])