topic Re: DAX for Conditional monitoring in DAX Commands and Tips

DAX for Conditional monitoring

sriramk — Sun, 30 Oct 2022 11:03:55 GMT

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=110503303817016536057&rtpof=true&sd=true

Re: DAX for Conditional monitoring

daXtreme — Sun, 30 Oct 2022 07:53:41 GMT

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.

Re: DAX for Conditional monitoring

sriramk — Sun, 30 Oct 2022 11:04:59 GMT

Hi, please check the below is helpful.

https://docs.google.com/spreadsheets/d/1qaSWtxpLXbsAYSa5TahjJD4Mi4HII4Hv/edit?usp=sharing&ouid=110503303817016536057&rtpof=true&sd=true

Re: DAX for Conditional monitoring

daXtreme — Mon, 31 Oct 2022 12:33:45 GMT

File attached...

Re: DAX for Conditional monitoring

sriramk — Tue, 01 Nov 2022 10:25:14 GMT

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!

Re: DAX for Conditional monitoring

daXtreme — Tue, 01 Nov 2022 19:58:58 GMT

Here you are... The change was cosmetic.