Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 bel...
Help with DAX Measure
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    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
    )
    )
camargos88's avatar
camargos88
Community Champion
5 years ago

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.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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
)
)