Get matching data from a Source file based on condition - Power Query

Hi bhaskarpbi999

 

You can add a custom column to flag rows where the Day Date matches the Week End date.

#"Added Custom" = Table.AddColumn(#"Promoted Headers", "Match", each if [Day Date] = [Week End Date] then "Match" else "No Match")

 

 

 

Your final code in the Power Query Editor will look something like this:

let
    //I. GET DYNAMIC PATH
    SourceRPT= PRM_SOURCES{[NAME="DIR XML"]}[PRM],
    //2. CSV, adjust Delimiter type and Columns accordingly
    Source = Csv.Document(File.Contents(SourceRPT),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Added Custom" = Table.AddColumn(#"Promoted Headers", "Match", each if [Day Date] = [Week End Date] then "Match" else "No Match"),
   
in
    #"Added Custom"

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.