Hi.
I'm trying to make a "Price Alert triggering" system with Pivot Tables.
First part is done. But I'm struggling to get the highest value of the closed price as a PowerPivot Table measurement. With the highest value I want to between the trigger price and the highest value as a measurement too but I can't really figure out how. I have tried to make the "highest price" formula with =CALCULATE(MAX('Sheet1'[CloseP])/SUM('Sheet1'[Price Trigger])) , but it didn't work out as I expected.
The file "Pirce Alert.xlsx" and the data source "Price info.xlsx" can be found at these links:
https://www.dropbox.com/s/rq13kbbusdh3rvy/Price%20Alert.xlsx
https://www.dropbox.com/s/qo44v0ydocdcg73/Price%20info.xlsx
Feel free to use and many thanks in advance for help!
//Chris
I'm trying to make a "Price Alert triggering" system with Pivot Tables.
First part is done. But I'm struggling to get the highest value of the closed price as a PowerPivot Table measurement. With the highest value I want to between the trigger price and the highest value as a measurement too but I can't really figure out how. I have tried to make the "highest price" formula with =CALCULATE(MAX('Sheet1'[CloseP])/SUM('Sheet1'[Price Trigger])) , but it didn't work out as I expected.
The file "Pirce Alert.xlsx" and the data source "Price info.xlsx" can be found at these links:
https://www.dropbox.com/s/rq13kbbusdh3rvy/Price%20Alert.xlsx
https://www.dropbox.com/s/qo44v0ydocdcg73/Price%20info.xlsx
Feel free to use and many thanks in advance for help!
//Chris
