Need help to convert an SQL query to DAX

PBIMDX 1 Reputation point
2021-09-30T08:45:53.007+00:00

select
cm.id,
case when CM.Manager=PM.Manager
then PM.Manager
else CM.Manager // in this part I would like to give it a differnt color if it was different value
End as Calc_Manager,
case when CM.Budget=PM.Budget
then PM.Budget
else CM.Budget // in this part I would like to give it a differnt color if it was different value
End as Calc_Budget

from (select * from TestChange where month(InTime)=9) CM
join (select * from TestChange where month(InTime)=8) PM
on PM.ID=CM.ID;

The data is like this in the table

ID InTime dept Manager Budget
101 2021-08-29 Dept1 Manager1 100000
101 2021-09-29 Dept1 Manager2 200000
102 2021-08-29 Dept2 Manager1 105000
102 2021-09-29 Dept2 Manager2 220000
103 2021-08-29 Dept3 Manager1 100000
103 2021-09-29 Dept3 Manager1 150000

if the data is different for two dates the field should be highlighted. Can anyone help on that :)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,769 questions