Switch tabel row value

[cbouichi]

Hi everybody,

i try too switch the "Oorzaak (groups)" row when its blank with the one that is not blank with the same "inspectienummerTermijn"

i try to use the measure in the matrix as below

Can someone help me?

[camargos88]

@cbouichi ,

You can use Power Query for it. Just sort the values by inspectienummerTermijn and use the Fill Down/Up.

https://www.myexcelonline.com/blog/fill-values-using-power-query/

You can also create another column like:

VALUE_2 = CALCULATE(MAX('Table'[VALUE]), FILTER('Table', 'Table'[ID] = EARLIER('Table'[ID]) && 'Table'[VALUE] <> BLANK()))

Be aware with the aggregation function, I've used MAX, you may need another one or even add an index to this table and get the previous nonblank value.

[cbouichi · Accepted solution]

thank you @camargos88 ,

fill down doesnt work in this senario because some of the value has to stay blank only the one with the same inspectienummerTermijn where a "oorzaak Group" is blank have to be filled

But i find a solution that worked for me. so i will place it here in cause somebody have the same problem.

Oorzaak =

VAR _id =

SELECTEDVALUE ( 'Meldingen&getCustominspecties'[InspectienummerTermijn] )

RETURN

CALCULATE (

MAX ( 'Meldingen&getCustominspecties'[Oorzaak (groups)] ),

FILTER (

ALL ( 'Meldingen&getCustominspecties' ),

'Meldingen&getCustominspecties'[InspectienummerTermijn] = _id

)

)