Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I want to dynamic change a cell in PowerBi.
If a cell is a date, then replace until next empty cell. Than repeat the same for another user.
So, under my colleague Betty there are cells with a date. The cell has te change to the name of my colleague, until the next empty cell. After that, there is my colleague Eddy. The same process needs to be done with Eddy as with Betty. The cells will change over time, because they will login more and more.
I thought, = if cell is date, than replace with name above until an empty cell. After that, repeat process.
Any help is very much appreciated.
Solved! Go to Solution.
Hi @GidionStals ,
I have created a simple smaple, please refer to it to see if it helps you.
Create a column first.
Column =
VAR _a =
MAXX (
FILTER ( 'Table', [Index] <= EARLIER ( 'Table'[Index] ) && [name] = "" ),
[Index]
)
VAR _b =
MINX (
FILTER (
'Table',
[Index] <= EARLIER ( 'Table'[Index] )
&& [Index] > _a
&& NOT ( CONTAINSSTRING ( [name], "/" ) )
),
[name]
)
RETURN
_b
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @GidionStals ,
I have created a simple smaple, please refer to it to see if it helps you.
Create a column first.
Column =
VAR _a =
MAXX (
FILTER ( 'Table', [Index] <= EARLIER ( 'Table'[Index] ) && [name] = "" ),
[Index]
)
VAR _b =
MINX (
FILTER (
'Table',
[Index] <= EARLIER ( 'Table'[Index] )
&& [Index] > _a
&& NOT ( CONTAINSSTRING ( [name], "/" ) )
),
[name]
)
RETURN
_b
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
84 | |
81 | |
72 | |
72 | |
55 |
User | Count |
---|---|
108 | |
105 | |
96 | |
86 | |
68 |