Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Tantanarsenal
Frequent Visitor

How to get the unique date and not earliest/latest etc.

Hi, 

 

I would like to know how to fix this issue. I have a matrix with a unique identifier as the last "+". When I click on the plus sign I would like to see the dates for every unique row but all I get is earliest/latest (which is ok to have on a subtotal row but not on a unique row)... Could somebody help me with this please?


2 REPLIES 2
Greg_Deckler
Super User
Super User

@Tantanarsenal Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

For example, here I have clicked on the plus and all the unique ID's have the same date (earliest), how do I fix this issue so it changes to the next example
                    Earliest date
- Name        2020-03-31
Unique ID 2020-03-31

Unique ID 2020-03-31

Unique ID 2020-03-31

Unique ID 2020-03-31

 

 

                    Date
- Name        2020-03-31
Unique ID 2020-03-31

Unique ID 2023-02-28

Unique ID 2022-03-31

Unique ID 2024-03-31

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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