Reply
sravan872
Frequent Visitor
Partially syndicated - Outbound

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.

2 ACCEPTED SOLUTIONS

Syndicated - Outbound

@sravan872 

here is a workaround for you.

 

11.PNG

 

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Syndicated - Outbound

Thank You, This works!

View solution in original post

6 REPLIES 6
sravan872
Frequent Visitor

Syndicated - Outbound

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.

sravan872
Frequent Visitor

Syndicated - Outbound

sravan872_0-1740122709715.png

This is the sample data

sravan872_1-1740122767047.png

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

sravan872_2-1740123152329.png

Please let me know if you need any further clarity. Thank You

 

 

Syndicated - Outbound

@sravan872 

here is a workaround for you.

 

11.PNG

 

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Syndicated - Outbound

Thank You, This works!

Syndicated - Outbound

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




rajendraongole1
Super User
Super User

Syndicated - Outbound

Hi @sravan872  - Can you share the sample data along with expected result. that helps to analyze.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)