Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Earliest and latest date

Hello guys,

I would like to show the earliest date and the latest date of my materialnumbers in my dataset? How can I fix this?

Thanks for your help !

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from Greg_Deckler and BIswajit_Das.

     

    Hi Anonymous ,

     

    Based on the existing replies, I created simple data and used measures to achieve the desired effect.

     

    This is the simple data:

     

    1.If you want to get the total earliest and latest dates, you can use the following measures:

     

     

    Maxdate = MAXX(ALL('Table'),'Table'[Date])
    Mindate = MINX(ALL('Table'),'Table'[Date])

     

     

    Result:

     

    2.To get the respective earliest and latest dates for each material number, use the following measures:

     

     

    Maxdate2 = CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[MaterialNumber]))
    Mindate2 = CALCULATE(MIN('Table'[Date]),ALLEXCEPT('Table','Table'[MaterialNumber]))

     

     

    Result:

    Best Regards,
    Zhu
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    1 year ago

    Anonymous Generally you would use MAX and MIN but not really enough information to be certain. 

     

    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.

  • BIswajit_Das's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual
    1 year ago

    Hello Anonymous 
    In-order to show the earliest date and the latest date you can sort the date column.
    If this isn't your issue then please share some demo data with how would you like to visualize the data
    Thanks & Regards...

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for the reply from Greg_Deckler and BIswajit_Das.

     

    Hi Anonymous ,

     

    Based on the existing replies, I created simple data and used measures to achieve the desired effect.

     

    This is the simple data:

     

    1.If you want to get the total earliest and latest dates, you can use the following measures:

     

     

    Maxdate = MAXX(ALL('Table'),'Table'[Date])
    Mindate = MINX(ALL('Table'),'Table'[Date])

     

     

    Result:

     

    2.To get the respective earliest and latest dates for each material number, use the following measures:

     

     

    Maxdate2 = CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[MaterialNumber]))
    Mindate2 = CALCULATE(MIN('Table'[Date]),ALLEXCEPT('Table','Table'[MaterialNumber]))

     

     

    Result:

    Best Regards,
    Zhu
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.