Forum Discussion

BradonK's avatar
BradonK
Frequent Visitor
9 months ago
Solved

How to Find Rows Missing from Table by Date

Hi,   I am trying to create a report that takes two tables. One is a list of breathalyser readings by date. The other is a list of signatures on a form by date. Below is an example. Breathalyser D...
Need Help
  • Arul's avatar
    Arul
    9 months ago

    BradonK ,

    try this in calculated column,

    VAR a1 = EXCEPT(Signatures,Breathalyser)
VAR a2 = EXCEPT(Breathalyser,Signatures)
VAR output = UNION(a1,a2)
RETURN output
v-achippa's avatar
v-achippa
Community Support
9 months ago

Hi BradonK,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you danextian, Arul, Ahmedx, Kedar_Pande for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa