SHOW CHANGE

[netanel]

Hey All!

I have 2 file Jan & Feb

The append its the file i work on

in the append i have a column call "file" that give me to a distinction between the files

I want to create a column that will show me the change between the January file and the February file
I mean if a person changed work ann site I will see the change in another column

Example of data:

Thanks!

[amitchandak]

@netanel ,

create a separate table with file name join with table

The create measure like

New measure =

var _file1=  calculate(max(Table[Job]) , filter(allselected(File), File[File] = "File1") )

var _file2=  calculate(max(Table[Job]) , filter(allselected(File), File[File] = "File2") )

return

if(Max(File[File]) ="File2" &&  _file1 <> _file2 , "red", "black")

Use this measure in conditional formatting using the field value option

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[netanel]

@amitchandak 

Hi thanks for the help but something goes wrong
Both in formula and in logic

In Excel it's simply Velookap between sheets
When the key is a Employee number\ID
Then where the columns are not same there is an N\A and this is an indicator that there is a change between the files
Here I understand need a calculated column or VAR as you did
But it does not work out

Maybe I did not explain myself well
Tell me what's missing and I'll try to be precise

Thanks!

[netanel · Accepted solution]

This is the Solution

_Site =

VAR _diff_Site =

CALCULATE (

MAX ( Append2[Finance Site] ),

FILTER (

Append2,

Append2[First Name] = EARLIER ( Append2[First Name] )

&& Append2[Person Number] = EARLIER ( Append2[Person Number] )

)

)

RETURN

IF ( _diff_Site <> Append2[Finance Site], "change", BLANK () )
Thanks All!