Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I would like a calculated Field to produce the "Type" field below in this context.
Date | Val1 | Val2 | Abs Value Diff | Type |
1/1/2018 | 5 | 4 | 1 | Mismatch |
1/2/2018 | 5 | 5 | 0 | Match |
1/3/2018 | 5 | 6 | 1 | Mismatch |
Here is the Calculated Column Formula I am currently using:
IF([Abs Value Diff] > 0,"MisMatch","Match")
My current output is producing these unwanted results:
auditDate | ABS Value Diff | Type |
1/1/2018 | 0 | Match |
1/1/2018 | 1 | MisMatch |
1/2/2018 | 0 | Match |
1/2/2018 | 0 | MisMatch |
1/3/2018 | 0 | Match |
1/3/2018 | -1 | MisMatch |
Hi @Anonymous,
As Ashish_Mathur said, please share some sample data, and show us the calculated formula of Val1, Val2 and Abs Value Diff.
Regards,
Yuliana Gu
Thank you for your responses and help. Let me clarify and answer your questions.
1. The only calculated measure in table below is "ABC - MH (ABS)"
ABC - MH (ABS) = ABS(
sum('Table1'[ABC]) - sum('Table1'[MH])
)
2. Add fields come from same table
How can I create a filter field (calculated column?) to view auditDates that have mismatched and matched counts?
auditDate | ABC | MH | ABC - MH (ABS) |
10/12/2018 | 4971 | 4971 | 0 |
10/13/2018 | 2115 | 2097 | 18 |
10/14/2018 | 952 | 952 | 0 |
10/15/2018 | 4699 | 4699 | 0 |
10/16/2018 | 6251 | 6240 | 11 |
10/17/2018 | 0 | 6245 | 6245 |
Hi,
You can simply created another measure
=IF([ABC - MH (ABS)]>0,"Mismatch","Match")
I think the issue is my data model date connection, but it seems correct, but obvisouly the table is showing otherwise.
Hi,
Share the link from where i can download your PBI file.
Hi,
What are Val1 and Val2? Share the base dataset (in a format that can be pasted in MS Excel).
Use the function ABS() to get the absolute difference.
Abs Value Diff = ABS(Value1 - Value2)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |