create status column need to see which id's are added and deleted every month dynamically.

[yuktadiya]

i have two columns id and month and month is text data type and id whole number data type

ID additions – Current month org units to be compared with previous month org units. Ex. 3,4 are added 

ID Deletions – Previous month org units will be compared with current month.  Ex. 2 is deleted 

Formula 

Additions = current month id's - previous month id's

deletions = previous month id's- current month id's 

id	month
1	june
2	june
1	july
3	july
4	july

how write dax for the for additions and deletions for every month 

Regards

Dilip

[Ahmedx]

pls try this

[yuktadiya]

need to see which id's are added and which id's are deleted 

[Ahmedx]

what result do you expect, write

[yuktadiya]

can see row by row additions 

3

4

can see row by row deletions

2

Regards

Dilip

[Ahmedx]

try this

[Ahmedx]

I didn’t understand you, show me how to line by line, show the result and what it should look like

[yuktadiya]

line by line means are added

3

4

line by line means are deleted 

2

Regards

Dilip

[Ahmedx · Accepted solution]

and try this