Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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
Solved! Go to Solution.
need to see which id's are added and which id's are deleted
what result do you expect, write
can see row by row additions
3
4
can see row by row deletions
2
Regards
Dilip
I didn’t understand you, show me how to line by line, show the result and what it should look like
line by line means are added
3
4
line by line means are deleted
2
Regards
Dilip