Creating a Measure

[faisayed]

Hi Friends,

I have a power bi sales dashboard which is been schedule and gets refreshed every 2 hours and its been screened on TV through power BI app.

One of the page in the dsahboard shows the number of minutes agents were on call for every hour  (Below is the snapshot of the same)

The data for this updated 2 times a day in google sheets. 
1. At 1 PM for 9AM to 1PM for same day

2. At 6 PM for 1PM to 6 PM for same day

Now when this dashboard is screened on TV the next day the title shows the weekday and date for present day as I have created a measure using Today (

Team Activity Title = "Team Activity, " & FORMAT(WEEKDAY(Today()),"dddd") & "," & " " & FORMAT(Today(),"DD-MMM-YY")

) where in the data is for yeasterday untli the data is updated at 1PM. 

So what i want is the tilte should show the weekday and date for yeasterday untill 1 PM and then after 1 PM it should change to Today's weekday and date and also on Monday's it should show the weekday and date of Friday until 1 PM and after 1 PM it should show the date and weekday for Monday.

Is there any possible way this can be acheived?

[amitchandak]

@faisayed , Do you need something like

Team Activity Title = "Team Activity, " & FORMAT(Today() -1 ,"DD-MMM-YY") & " 1 PM Onward to " & FORMAT(Today()  ,"DD-MMM-YY") 

[faisayed]

@amitchandak 

Nope.
What I want is the header "Team Activity, Monday 17-Oct-2022" should be dynamic.
The table visual header is representing has data for previous day until 1PM present day.

e.g. On Tuesday till 1 PM the visual shows data for Monday (9AM - 6PM) and after 1 PM the data is updated and then it shows the data for Tuesday((9AM - 1PM).

So what i want is until 1 PM the header should read as "Team Activity, Monday 17-Oct-2022"  and after 1 PM it shoud read as "Team Activity, Tuesday 18-Oct-2022".

Hope I was clear and able to explain what actually i need 🙂