Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cbouichi
Helper IV
Helper IV

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"

Schermafbeelding 2020-11-09 190018.png

i try to use the measure in the matrix as below

image.png

 

Can someone help me?

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

View solution in original post

2 REPLIES 2
camargos88
Community Champion
Community Champion

@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:

Capture.PNG

 

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.

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors