Counting days to new peaks

ThornTech — Thu, 10 Nov 2022 20:58:54 GMT

I'm building out a Dashboard to carry out analysis on Backtest results from Algo trading. For the most part it's going well, but I'm stuck on 1 aspect at the moment.

I have the following date where:

Date is from a date table

Balance is from the raw data

Peak is calculated via a standard Dax shown under the table

Concurrency is where I'm stuck, I want to count the number of days the peak stays the same so I can calc the amount of days between peaks.

Any advice would be appreciated. Thanks Chris

Date	Balance	Peak	Concurrency
01/01/2022	1000	1000	1
02/01/2022	1005	1005	1
02/01/2022	900	1005	2
02/01/2022	950	1005	3
02/01/2022	1100	1100	1

Peak Strat = MAXX(FILTER(ALLSELECTED('FX Export Primary'), 'FX Export Primary'[Trade UID] <=MAX('FX Export Primary'[Trade UID])),'FX Export Primary'[Equity])

Re: Counting days to new peaks

Anonymous — Fri, 11 Nov 2022 02:57:50 GMT

H ThornTech,

I'd like to suggest you extract the current date from the calendar table and use it and user id as conditions to filter table records and get corresponding results:

Peak Strat = VAR currDate = MAX ( Calendar[Date] ) RETURN CALCULATE ( MAX ( 'FX Export Primary'[Equity] ), FILTER ( ALLSELECTED ( 'FX Export Primary' ), 'FX Export Primary'[Date] <= currDate ), VALUES ( 'FX Export Primary'[UID] ) )

If these also don't help, please share some dummy data or pbix file with expected results to help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

topic Counting days to new peaks in DAX Commands and Tips

Counting days to new peaks

Re: Counting days to new peaks