cancel
Showing results for
Did you mean:
Helper III

## Re: Finding first date shared by multiple products

Hi Ashish

Here is my full data set

Super User IV

## Re: Finding first date shared by multiple products

Hi,

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted
Super User IV

## Re: Finding first date shared by multiple products

Try these calculated field formulas

Date of investment.  This field is not really required.  It is just for your information.

`=CALCULATE(MIN(Returns[Date]),ALL('Calendar'))`

Date of inititation for return calculation

`=MAXX(SUMMARIZE(ALL(Returns),[Fund],"ABCD",MIN(Returns[Date])),[ABCD])`

Returns

`=CALCULATE(SUM(Returns[Performance]),DATESBETWEEN('Calendar'[Date],[Date of initation for return calculation],MAX('Calendar'[Date])))`

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper III

## Re: Finding first date shared by multiple products

That hasn't worked for me.

If the Portfolios selected are "Equity Fund" and "ALSI" I need to get my begin date to be "2006/06/30".

If I select "Equity Fund" and "ALSI" and "Balanced Fund" I need to get my begin date to be "2013/10/31".

Super User IV

## Re: Finding first date shared by multiple products

It is working fine.  I changed the formula a bit and removed the visual level filters.  The file is at the same link.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper III

## Re: Finding first date shared by multiple products

I see that it is working by itself. Please look at my latest PBIX file with your measures and my full data. You'll see if created a measure using GroupBy that gets to the same answer too.

If I use your "First Initiation Date" measure in a table by itself (bottom table) I get the correct answer with both our formulas.

But the objective of the formula is to use it in a table (top table) to get the correct start date for the performance figures for the specified month.

Currently, the StartDate formulas don't work if I've specified the latest month in the visual slicer. Or the performance measures don't work if I haven't specified the month on the visual slicer.

I'm not sure which one should be changed.

Thank you for the help so far. I hope this challenge is interesting to you...

Super User IV

## Re: Finding first date shared by multiple products

Hi,

Why should there be 2 dates selection routes - you have dragged dates both to the filter section and are also using it as a slicer.  Keep any one of them.  Select a date/date range there and then see the result of my formula.  If you still face problems, please let me know exactly with which selection do you face a problem.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper III

## Re: Finding first date shared by multiple products

Thanks for all the help!

These are the formulas I used to reach my desired result.

```FirstSharedDate =
CALCULATE (
MAXX (
SUMMARIZE (
ALLSELECTED ( AllPerfMnthly[Portfolio] ),
[Portfolio],
"ABCD", MIN ( AllPerfMnthly[Date] )
),
[ABCD]
),
ALLEXCEPT ( AllPerfMnthly, AllPerfMnthly[Portfolio] )
)

InceptionDate =
CALCULATE (
FIRSTNONBLANK ( AllPerfMnthly[Date], AllPerfMnthly[Date] ),
ALLEXCEPT ( AllPerfMnthly, AllPerfMnthly[Portfolio] )
)```

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors