Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
faisayed
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)

faisayed_2-1666076158151.png

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?

 

 

 

 

 

2 REPLIES 2
amitchandak
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") 

@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 🙂

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.