Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I have a query related to conditional monitoring of values. The data table and expected output are given below. Requesting help to solve. Thank you in advance!
Tables:
QUERY:
To Find and highlight the W.S where the value is less than half of max value at specific time, add status column and create a anamoly table.
Expected Output:
Sample data here https://docs.google.com/spreadsheets/d/1qaSWtxpLXbsAYSa5TahjJD4Mi4HII4Hv/edit?usp=sharing&ouid=11050...
Solved! Go to Solution.
Here you are... The change was cosmetic.
This should not be that hard... Can you please post a link to a file with raw data? I understand that the pictures above show data that's already been pulled out of a model into a visual. Hence my request for raw data. I wouldn't like to waste time to create such data myself by hand. Waste of time and effort. Thanks.
Hi, please check the below is helpful.
https://docs.google.com/spreadsheets/d/1qaSWtxpLXbsAYSa5TahjJD4Mi4HII4Hv/edit?usp=sharing&ouid=11050...
Hi,
Thank you for your efforts!
I will put my query again,
From the image below, value highlight should be based on less than 50% of Max. value. Here at 08:00, W1.S4 value is 2.53 which is less than 50% of Max value ie., 2.725.
Also, could you please help me with creating Anamoly table (contains time and W.S of highlighted values) similar to below?
Thank you again for your support!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |