Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
yuktadiya
Helper II
Helper II

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

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 

 

idmonth
1june
2june
1july

3

july

4

july

 

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

 

Regards

Dilip

1 ACCEPTED SOLUTION

8 REPLIES 8
Ahmedx
Super User
Super User

pls try this

Screenshot_1.png

yuktadiya
Helper II
Helper II

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

Ahmedx
Super User
Super User

what result do you expect, write

 

can see row by row additions 

3

4

can see row by row deletions

2

 

Regards

Dilip

 

try this

 

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

 

and try this

Screenshot_1.png

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors