Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
So i have an streaming data set, and i created an measure to get the latest value of an item.
What i want to do is: i have 2 temperature sensors, if one of them goes above 25 degrees i want to return an 1(like i did for one is temp_green = IF('RealTimeData'[Latest_temp] < 25, 1, 0). How do i manage to create an IF(latest_temp > 25 and device = 'Device1' or 'Device2' return 1
Or like if a device has an measure of > 25 turn something to true so i can do this IF(temp = true, 1, 0)
I hope someone can help me
Can you post sample data as text and expected output?
Not enough information to go on;
please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Name of column and structure of your table is important.
BTW, You need somthing like this:
IF('RealTimeData'[Latest_temp] < 25 && ('RealTimeData'[device ]="Device1"|| 'RealTimeData'[device ]="Device2", 1, 0)
Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |