see a change from file to file

[netanel]

Hello everyone!

I would love creative thinking and help
I have a file of employees that is updated twice a month
The structure is fixed
I just need to bounce the changes from file to file
That is, if an employee changed his status in the first file versus the second file

Anyone have an idea?

[Anonymous]

Hi @netanel ,

Please refer to my pbix file to see if it helps you.

Create two measures.

_se = IF(NOT(CONTAINS(b,b[SEGMENT],MAX(a[SEGMENT]))),"red")

_job = IF(not(CONTAINS(b,b[JOB],MAX(a[JOB]))),"red")

Then Conditional formatting of them.

If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[netanel]

@Anonymous 

Wow what an answer!
Thank you!
Easy change
I'm working on a table that combines the two files (Append )
There is only one column that separates the a & b she call "File" column
2. Instead of painting in red, it is possible to add a column that says Change
Whenever there was a change? Like what you painted in red

Thank you so mach!!

[Anonymous · Accepted solution]

Hi @netanel ,

Please refer to my pbix to see if it helps you.

Create columns.

_segm =
VAR _diff =
    CALCULATE (
        MAX ( Append1[SEGMENT] ),
        FILTER (
            Append1,
            Append1[NAME] = EARLIER ( Append1[NAME] )
                && Append1[ID NUMBER] = EARLIER ( Append1[ID NUMBER] )
        )
    )
RETURN
    IF ( _diff <> Append1[SEGMENT], "change", BLANK () )

_job =
VAR _diff_job =
    CALCULATE (
        MAX ( Append1[JOB] ),
        FILTER (
            Append1,
            Append1[NAME] = EARLIER ( Append1[NAME] )
                && Append1[ID NUMBER] = EARLIER ( Append1[ID NUMBER] )
        )
    )
RETURN
    IF ( _diff_job <> Append1[JOB], "change", BLANK () )

If I have misunderstood your meaning, please provide your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[netanel]

@Anonymous 

Another little thing
Beyond the change from record to record you managed to mark excellently
Sometimes there are more or less people between files
How can I find it too?

[netanel]

@Anonymous 

This is exactly what I was looking for
Thank you!

[netanel]

Hello everyone,
I want to create a calculated column that will tell me the difference
Between person and person according to FILE
how do I do it? (The change is marked in red)

[amitchandak]

@netanel , If you need based on slicer then you need 1 or independent table with file name

As of now for only 2 files without any slicer, 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 

I'm not sure this is the solution but it definitely gives me direction
There is a problem with If
Another idea?

[mh2587]

Is file 1 and file 2 are seperate tables or single table?

[netanel]

Hey @mh2587 

Thanks for the quick respons!

They are one table
I did Append to them
So I need one or a few columns that will show me the difference between the file
In relation to a person whether he has changed type of work or city

[amitchandak]

@netanel , On is having two tables and create common dimensions and analyze them,

Or try to use DAX append to have data in same table

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[netanel]

Hey @amitchandak 

On is having two tables and create common dimensions and analyze them,

This is exactly what I started to do (Attached Image)
But I want to bounce the difference in each DIM clearly and quickly
So looking for an idea
Regarding the append attached is excellent and I am working on something like this thanks!

But is there a solution in DAX or a simple Measure to bounce differences?

1.The difference between a file and a file in a certain dimension

2.My database and file-to-file change are marked in red

Thanks!