Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Max Date Count

Hello,   I am pretty new to power bi and would like to calculate the sum of the max date in the below table Product Id Date 1 7/21/2021 18:49 2 7/20/2021 18:49 3 7/19/2021 18:49 ...
Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous ,

 

You can try below code:-

count_of_dates = 
CALCULATE ( COUNT ( 'Product_data'[Date] ), LASTDATE('Product_data'[Date]) )

output:-

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you so much. That worked. One last question. if I use the similar table with few more information :

    ProductDateNameADDRESS
    17/21/2021 18:49Aabc
    27/20/2021 18:49Bdef
    37/19/2021 18:49Cdhk
    47/20/2021 18:49Dscj
    57/21/2021 18:49Esbn
    67/22/2021 18:49Fsjx
    77/22/2021 18:49Gscn
    87/22/2021 18:49Hivd
    97/22/2021 18:49Iskl
    107/22/2021 18:49Jkjs

     

    Now I want to create a table with product, name and address using the max date, how do I do that?

    • Samarth_18's avatar
      Samarth_18
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Hi Anonymous 

       

      You can directly drag your fields on table visual and take a latest of your date. PFB screenshot for reference:-

       

      Note:- You can get latest option when you right click on Date in Values Pane