- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Measure for net gain/loss
Hello, i'm trying to calculate the net gain or loss using two different date columns. One column is 'join date' and the other is called 'leave date'. Join date always has a value and leave date might not if someone is still active.
I'm not sure how to do this in DAX as i need to COUNT distinct ID's, for both date columns and then calculate the difference between each yearly value:
Any ideas?
thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @rogerdea ,
You will need to unpivot the columns JoinDate and LeaveDate.
Click on Unpivot Columns
After unpivoting your table will look like below.
Create a Calculated Column
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @rogerdea ,
You will need to unpivot the columns JoinDate and LeaveDate.
Click on Unpivot Columns
After unpivoting your table will look like below.
Create a Calculated Column
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi roger
Why does 1212, 2099 and 1313 rejoin in overlapping periods and how do you want these overlaps counted please?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-19-2021 09:05 AM | |||
Anonymous
| 05-16-2021 02:05 PM | ||
12-12-2023 02:32 AM | |||
08-18-2022 03:01 PM | |||
Anonymous
| 02-18-2022 01:52 PM |
User | Count |
---|---|
13 | |
13 | |
11 | |
10 | |
8 |