- 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

Power BI DAX - Need help
Hi,
I have a single table with fund code, effective date, issuer name, si score, portfolio weight etc... Now I have 2 slicers fund code and effective date, when i select a particular fund code and effective date in the slicer I need to display new issuer names and lost issuer names for that selected fund code when compared to previous month from the selected effective date in the slicer. The dates in the effective date slicer are all month end dates(eg: 11/30/2024, 12/31/2024, 1/31/2025). how to acheive this ? the data is in direct query mode.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

here is a workaround for you.
pls see the attachment below
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

New Issuers: From the selected date in the slicer, it should compare with last month issuers and give the issuer names added newly in this month.
Lost Issuers: From the selected date in the slicer, it should compare with last month issuers and give the issuer names lost in this month.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

This is the sample data
If i select fund code as A and Effective Date as 1/31/2025, It should compare the issuer names with the last month and give the result as below
Please let me know if you need any further clarity. Thank You
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

here is a workaround for you.
pls see the attachment below
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank You, This works!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

you are welcome
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @sravan872 - Can you share the sample data along with expected result. that helps to analyze.
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-16-2024 08:36 AM | |||
06-05-2023 05:09 AM | |||
01-20-2024 06:58 PM | |||
03-14-2023 05:39 AM | |||
Anonymous
| 06-25-2024 01:32 AM |
User | Count |
---|---|
114 | |
90 | |
86 | |
54 | |
46 |