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).
Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.