I would like a calculated Field to produce the "Type" field below in this context.
|Val1||Val2||Abs Value Diff||Type|
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|
As Ashish_Mathur said, please share some sample data, and show us the calculated formula of Val1, Val2 and Abs Value Diff.
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)|
You can simply created another measure
=IF([ABC - MH (ABS)]>0,"Mismatch","Match")
Share the link from where i can download your PBI file.
What are Val1 and Val2? Share the base dataset (in a format that can be pasted in MS Excel).
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.