logic to calculate Min and Max value for the day.

[lalitkgehlot89]

Hi,

In given Qvw. I want to calculate Min & Max temp value on a range of load in text box.

Half Load :-  Generator MW between (350 & 380)

Full Load :-  Generator MW between (670 & 705)

In Case Load range not present in max date then it will show previous day value.

[tresesco]

Try like:

=max({<[GENERATOR MW]={">=350<=380"}>}[MS LINE A TEMP]) & '        '

& FirstSortedValue({<[GENERATOR MW]={">=350<=380"}>} BLOCK,-[MS LINE A TEMP])&','&

Date(FirstSortedValue({<[GENERATOR MW]={">=350<=380"}>} LINKDATE,-[MS LINE A TEMP]) )

The rest you could adjust similarly by changing the range and max()/min().

[lalitkgehlot89]

Thanks a lot Tresesco,

It is working fine with date selection. But data should be show without any selection.

I did some changes in qvw by the help of that it is working fine.

I have one more scenario suppose on max of date (30-07-2018). i don't have  Half load range(350-380) data.

In this case it should show last day data when Half load range was (350-380).