comparing 2 date columns from 2 different tables with each other

Question

Hi All, I am new to power bi , and in the start itself I have got a complex requirementI have 2 tables consisting of date field in each as shown below:Table 1:DateToBeChecked2024-05-052024-04-252024-03-132024-03-032024-02-11&nbsp;Table 2:DateToBeCompared2024-05-312024-04-282024-03-202024-03-102024-02-15&nbsp;There is no active relationship between 2 tables.Expected Result:I want to check whether DateToBeChecked&lt;=DateToBeCompared, if the condition is true then I want to show that result, also if condition is false then I want to show Result as blank for higher dates along with less than dates. For Example:Scen1: DateToBeCompared IS 2024-04-28 Then result should be:DateToBeChecked&nbsp;2024-04-252024-03-132024-03-032024-02-11&nbsp;Scen2: DateToBeCompared=2024-03-20 Then result should be:DateToBeChecked&nbsp;&nbsp;2024-03-132024-03-032024-02-11&nbsp;Scen3: DateToBeCompared IS 2024-03-10 Then result should be:DateToBeChecked&nbsp;&nbsp;&nbsp;2024-03-032024-02-11To try this out I have used if statement along with selectedvalue(DateToBeCompared) but getting result as blank.&nbsp;Can someone please help?quantumudit&nbsp;quantumudit1&nbsp;&nbsp; &nbsp;Anonymous&nbsp;Ashish_Mathur&nbsp;dufoq3&nbsp;Anonymous&nbsp;

dufoq3 · Answer

@Hi&nbsp;aatish178,&nbsp;you asked in POWER QUERY forum so here you have PQ solution:
&nbsp;
Result:

&nbsp;
let
    DateToBeChecked = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMtE1MAUipVgdGNdE1wiZa6xraIzCNUDmGukaGirFxgIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t]),
    DateToBeCompared = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMtE1MNU1NlSK1YFxTXSNLJC4xrpGBihcQ2Suka6hqVJsLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t]),
    ComparedDates = List.Accumulate(
        DateToBeCompared[Date],
        DateToBeChecked,
        (s,c)=&gt; Table.AddColumn(s, c, each if Date.From([Date]) &lt;= Date.From(c) then c else null , type text)
),
    RenamedColumns = Table.RenameColumns(ComparedDates,{{"Date", "▼Checked | Compared ►"}})
in
    RenamedColumns
&nbsp;

aatish178 · Answer

Hi, thanks..I want to implement this logic for front end table visual

aatish178 · Answer

hi all, can someone plz help me with some possible solution

Forum Discussion

Related content

Compare two columns in different tables

Comparing Difference between two columns in two different tables

DAX or Query: Compare two columns in different Tables

Compare two date columns from different tables

Compare different tables