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.
Good afternoon everyone, I need help bringing information from my previous line, I will describe here what I am doing.
Based on the table below:
From this table I need to add another column named "Recurso" where I must put the name that comes before the dates.
Use the formula below to find the name:
= Table.AddColumn(#"Inserção de Coluna Index", "Recurso", each
let
CurrentData = [Data],
PreviousData = if [Index] > 0 then {[Index]-1}[Recurso] else null
in
if Text.Contains(CurrentData, "/") then PreviousData else CurrentData
)
What I'm not able to solve is copying the information from the previous line "Recurso" and rewriting it in the "Recurso" column when my column is a date, below is the image of the result obtained:
Solved! Go to Solution.
Do you mean you want to get the name for each section on the same row as the date?
--
I think the code provided can be simplified:
if Text.Contains([Data], "/") then null else [Data])
then do a Fill.Down on the column
Do you mean you want to get the name for each section on the same row as the date?
--
I think the code provided can be simplified:
if Text.Contains([Data], "/") then null else [Data])
then do a Fill.Down on the column
You're right, I didn't understand at first, setting everything to null I can do the filldown later.
Thank you very much.
What I need is that when it doesn't identify the "/" of the date, it retrieves the information from the previous line that I'm filling in.
Example, if you don't find "/" take the name information and write it in "Recurso", if you don't find "/" return the name placed on the previous line of "Recurso"
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.