Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Struggling to get this to work... See attached sample.
I have Person / Activity Type / Date.
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
Member Status Update Date | SubTYpe | |
JOHN | 01/01/2010 00:00 | Website Live Chat |
MASSIMO | 06/07/2009 00:00 | Website Live Chat |
Solved! Go to 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)
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)
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?
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/
Hi @Massig.
Try this out.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |