cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gcobanim Regular Visitor
Regular Visitor

Set up alert for temperature above 30% to your mail

Hi Team

 

I have field from the table in my Table in power bi, i want to set an alert on my dashboard using either card or gauge. How do i go about using this scenario? meaning in powerbi as to say set an alert to a user if temperature is above 30% celcious as an email? Do i do iteration function like MAX(.sum(table_name.) or Conditional function like IF temperature is 30% then do.... or else below do this...... Kindly please assist as i want to implement such to my power bi dataset, an example will be appreciated thanks team.

1 ACCEPTED SOLUTION

Accepted Solutions
artemus Member
Member

Re: Set up alert for temperature above 30% to your mail

You wouldn't want to use SUM... there is no point in summing tempatures.

 

What you probably want is to show the tempature at the latest time point.

Something like:

temperatureLatest = SELECTCOLUMNS(TOPN(1,[TemperatureTable], [DateTime],DESC), "Temperature", [Temperature])

View solution in original post

1 REPLY 1
artemus Member
Member

Re: Set up alert for temperature above 30% to your mail

You wouldn't want to use SUM... there is no point in summing tempatures.

 

What you probably want is to show the tempature at the latest time point.

Something like:

temperatureLatest = SELECTCOLUMNS(TOPN(1,[TemperatureTable], [DateTime],DESC), "Temperature", [Temperature])

View solution in original post

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 367 members 3,132 guests
Please welcome our newest community members: