Fill in value from the line below

[kasife]

Hey guys,
I have a matrix with the release date, the stock completion date, and the gap (time from stock completion to the next release. What I would like to get is that if the gap is negative, it also fills in with the same color as the next launch that is on the line below.
How could I create a measure?

[amitchandak · Accepted solution]

@kasife , You can get the next release date in a column

next = Minx(filter(Table, [release Date] > earlier([release date]) ), [release date])

you can take a diff

diff = datediff([Stock Check out],[next], day)

you can now use conditional formatting. you can create a measure and use that in conditional formatting using field value option 

if( Sum(Table[Diff]) >0 , "Green", "Red")

Learn Power BI Advance - PowerBI Abstract Thesis:
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s