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 have a fixed column named "Plan"and I want to compare its Restriction over 2 months and flag the rows which changed.
To make the question more clear, below are the details. Can someone please help ?
Plan name | Restriction for May'18 | Restriction for June'18 | Expected result |
A | PA | PA | No Change |
B | QA | ST | Change |
C | ST | PA | Change |
D | PA | ST | Change |
Solved! Go to Solution.
Use below DAX, before that Please create the Relation between both the Tables the Create the Calculated Column
Expected Results = IF ( 'Sales Data'[Customer Name Index] = RELATED ( 'Customer Data'[Customer Index] ), "No Change", "Change" )
Regards,
Chetan K
Use below DAX, before that Please create the Relation between both the Tables the Create the Calculated Column
Expected Results = IF ( 'Sales Data'[Customer Name Index] = RELATED ( 'Customer Data'[Customer Index] ), "No Change", "Change" )
Regards,
Chetan K
For this sample data, you can create a calculated column with the below formula.
COmparision=IF(Table1[Restriction for May'18]=Table1[Restriction for June'18], "No Change", "Change")
Thanks
Raj
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 |
---|---|
116 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |