Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi ,
Based on below data , i want to check whether any source (A) policy number can be found in source (B)
for each date_run group .
I need an output like below. here main thing is last two rows for source B having duplicate policy number rows ,that one i did not included in duplicate because that policy number was repeated only in source B not in B.
please help for solve this problem
Hi @NISHA_S
The last B rows are same but there is a similar row with source A which needs to change the dulp to Yes not No(Check this).
BTW, try this DAX to add a calculated column:
dupl =
IF (
MAXX (
CALCULATETABLE (
SUMMARIZE ( 'Table', 'Table'[policy], "CSD", DISTINCTCOUNT ( 'Table'[source] ) ),
REMOVEFILTERS ( 'Table'[source], 'Table'[date_run] )
),
[CSD]
) > 1,
"Yes",
"No"
)
output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
User | Count |
---|---|
117 | |
74 | |
62 | |
50 | |
46 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |