Forum Discussion
The difference between the earliest two dates
Hello, I have the table shown, I need a measure (1) that calculates the difference between the earliest two dates and measure (2) how many times the price changed. https://docs.google.com/s...
Simple enough,
Cnt = CALCULATE( COUNTROWS( 'PRICE' ), 'PRICE'[#] <= MAXX( INDEX( 2, DISTINCT( 'PRICE' ), ORDERBY( 'PRICE'[Date], DESC ) ), 'PRICE'[#] ) ) - 1Hi,
PBI file attached.
Hope this helps.
Hi,
PBI file attached.
Hope this helps.