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

[Massig]

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

I have Person / Activity Type / Date.

Email	Member Status Update Date	SubTYpe
JOHN	01/01/2010 00:00	Website Live Chat
JOHN	02/01/2013 00:00	Website Live Chat
JOHN	02/02/2013 00:00	Website Educational Material
JOHN	05/05/2017 00:00	Website Educational Material
JOHN	06/06/2019 00:00	Webinar WW TM
MASSIMO	06/07/2009 00:00	Website Live Chat
MASSIMO	21/09/2009 00:00	Webinar WW TM
MASSIMO	22/08/2012 00:00	Corporate
MASSIMO	30/08/2012 00:00	Webinar Recording Desktop
MASSIMO	30/08/2012 00:00	Website Brochure download
MASSIMO	30/08/2012 00:00	Website Educational Material
MASSIMO	15/09/2013 00:00	Website Brochure download
MASSIMO	30/09/2013 00:00	Website Brochure download
MASSIMO	30/09/2013 00:00	Website Interactive
MASSIMO	02/02/2015 00:00	Website Educational Material
MASSIMO	14/04/2015 00:00	Website Interactive
MASSIMO	16/04/2015 00:00	Webinar 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

Email	Member Status Update Date	SubTYpe
JOHN	01/01/2010 00:00	Website Live Chat
MASSIMO	06/07/2009 00:00	Website Live Chat

[v-juanli-msft · Accepted solution]

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)

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.

[Massig]

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]

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.

[v-juanli-msft]

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.

[damj]

Hi @Massig.

Try this out.

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])