Forum Discussion

Frequent Visitor

4 years ago

Solved

Only show rows when value is changed (based on date)

Hi all, I'm fairly new in the community and I'm struggling with this issue for over weeks now. I hope somebody can help me out: I have a table with 4 columns: * WKN = my ID * AARDCONT = th...

4 years ago

Needs REMOVEFILTERS

Row Is Visible = 
var bdValues = CALCULATETABLE( VALUES( 'data'[WKN]), REMOVEFILTERS(data), 'data'[AARDCONT] = "BD", USERELATIONSHIP('Calendar'[Date], 'data'[Till]) )
var odValues = CALCULATETABLE( VALUES('data'[WKN]), REMOVEFILTERS(data), 'data'[AARDCONT] = "OD")
return IF( SELECTEDVALUE( 'data'[WKN] ) IN INTERSECT( bdValues, odValues), 1, 0)