The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
14 | |
9 | |
7 |