Count of changes between two dates

Question

Hi,&nbsp;Just say I have this table in BI.&nbsp;Location &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rack 1 (quant) &nbsp; &nbsp; &nbsp; &nbsp;Rack 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rack 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DateS1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;33 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/4/17S1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/5/17S2S2S2S3.....&nbsp;I want to calculate the differences in the Rack columns between the last two dates and display it in the same record as the last date.&nbsp;So, I would have new column/measure that would say Rack 1 change = 1, Rack 2 change = 8, Rack 3&nbsp;change = -25&nbsp;Is this even possible??

cs_skit · Answer

In some cases referencing last row is easy like here in a calculated column:

some cases you need more like in this example where I used date to rank and you can also use additional conditions in that expression:

http://community.powerbi.com/t5/Desktop/Last-country-visited-timeline-logic/m-p/206028#M90786

hope this helps you get a solution

Forum Discussion

Count of changes between two dates

1 Reply

Related content

Counting nulls

Count Of Drivers

Count Measure

count distinct

Counting Non-Blank Records