Forum Discussion
Switch tabel row value
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?
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] )RETURNCALCULATE (MAX ( 'Meldingen&getCustominspecties'[Oorzaak (groups)] ),FILTER (ALL ( 'Meldingen&getCustominspecties' ),'Meldingen&getCustominspecties'[InspectienummerTermijn] = _id))
2 Replies
Anonymous ,
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.
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] )RETURNCALCULATE (MAX ( 'Meldingen&getCustominspecties'[Oorzaak (groups)] ),FILTER (ALL ( 'Meldingen&getCustominspecties' ),'Meldingen&getCustominspecties'[InspectienummerTermijn] = _id))
