cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Massig
Frequent Visitor

Help in getting to display first date of all categories of an activity

Struggling to get this to work... See attached sample.

I have Person / Activity Type / Date.

EmailMember Status Update DateSubTYpe 
JOHN01/01/2010 00:00Website Live Chat
JOHN02/01/2013 00:00Website Live Chat
JOHN02/02/2013 00:00Website Educational Material
JOHN05/05/2017 00:00Website Educational Material
JOHN06/06/2019 00:00Webinar WW TM
MASSIMO06/07/2009 00:00Website Live Chat
MASSIMO21/09/2009 00:00Webinar WW TM
MASSIMO22/08/2012 00:00Corporate
MASSIMO30/08/2012 00:00Webinar Recording Desktop
MASSIMO30/08/2012 00:00Website Brochure download
MASSIMO30/08/2012 00:00Website Educational Material
MASSIMO15/09/2013 00:00Website Brochure download
MASSIMO30/09/2013 00:00Website Brochure download
MASSIMO30/09/2013 00:00Website Interactive
MASSIMO02/02/2015 00:00Website Educational Material
MASSIMO14/04/2015 00:00Website Interactive
MASSIMO16/04/2015 00:00Webinar WW TM

I would like to display as a result just the first activity across all categories... I am new to Power BI and stuck ... it shows the first per category ... but not the absolute first only.

 

My desired outcome would be:

Here is the sample file. https://file.io/f1a1sN

EmailMember Status Update DateSubTYpe
JOHN01/01/2010 00:00Website Live Chat
MASSIMO06/07/2009 00:00

Website Live Chat

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Help in getting to display first date of all categories of an activity

Hi @Massig 

Change "Member Status Update Date" to date/time format,

Create a measure

Measure = IF(MAX('Table'[Member Status Update Date])=CALCULATE(MIN([Member Status Update Date]),ALLEXCEPT('Table','Table'[Email])),1,0)

Capture6.JPG

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
damj
Frequent Visitor

Re: Help in getting to display first date of all categories of an activity

Hi @Massig.

 

Try this out.

Udklip.PNG

earliest date =
var SubTYpe_filtered = calculate(min(Ark1[Member Status Update Date]);filter(allexcept(Ark1;Ark1[Email];Ark1[SubTYpe]);Ark1[Member Status Update Date] <= earlier(Ark1[Member Status Update Date])))
return if(SubTYpe_filtered=Ark1[Member Status Update Date];Ark1[Member Status Update Date])
Community Support
Community Support

Re: Help in getting to display first date of all categories of an activity

Hi @Massig 

Change "Member Status Update Date" to date/time format,

Create a measure

Measure = IF(MAX('Table'[Member Status Update Date])=CALCULATE(MIN([Member Status Update Date]),ALLEXCEPT('Table','Table'[Email])),1,0)

Capture6.JPG

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Massig
Frequent Visitor

Re: Help in getting to display first date of all categories of an activity

Great - thank you!
That worked...

 

So onto my next hurdle...

I have the visualization ... it has around 300,000 lines...

 

I am struggling to export it... 

Is there any way to output it in CSV ... view it from Excel ...export it in any way?

Massig
Frequent Visitor

Re: Help in getting to display first date of all categories of an activity

Just tried to make a table that I can copy and paste in Excel and failed to make it work with the calculations of the visualization.
Community Support
Community Support

Re: Help in getting to display first date of all categories of an activity

Hi @Massig 

Export data from a visual to csv file in Power BI Desktop.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

 

It seems your data meet the limitation of "export to data" function above, you could also consider any other workaround:

https://blog.crossjoin.co.uk/2018/02/05/creating-excel-data-dump-reports-from-power-bi/

https://www.powerbi-pro.com/en/import-data-from-power-bi-desktop-into-excel/

https://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks Launched March 24th!

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!

‘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

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.

Top Solution Authors
Top Kudoed Authors