Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Creating a Measure

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?






Super User
Super User

@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") 


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 🙂

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors