Forum Discussion

Manasi25's avatar
Manasi25
Helper II
1 year ago
Solved

Show visuals only latest date data

Hello Team,

I have daily update data with N number of rows, i want to present only latest data in visuals.

I have created DAX , but its only showing me top 1 number data data. I want to show whole data of the day.
data :- 


DAX :-



Need Help
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi Manasi25 ,

    Thanks for reaching out to the Microsoft fabric community forum.

     

    The DAX formula MAX('Sheet1'[Login Date]), which always picks the latest date (Login Date)  in the dataset. As new data is added, If new rows have a more recent date, the MAX function picks it up. The CALCULATETABLE condition filters the data to match this new latest date.

     

    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
    Thanks and Regards

     

     

     

     

8 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    Hi,

    Share some data, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    1 year ago

    Manasi25 

     you login date contains time value, so you max will return the lastest date and time. If you want to display the latest date, you can try to create a new column

     

    login date2= int(login date)

     

    then change login date to login date 2 in your DAX. 

  • v-priyankata's avatar
    v-priyankata
    Community Support
    1 year ago

    Hi Manasi25 ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    I took sample data. Based on your data snap.

     

    steps to follow:

    1. create Table1 (Sheet1) with sample data.

     

    2. create Table2 (calculated table) based on the below code

     

    LatestData = CALCULATETABLE('Sheet1','Sheet1'[Login Date]=MAX(Sheet1[Login Date]))

     

     

     

    If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

     

    Thank you

    • Manasi25's avatar
      Manasi25
      Helper II
      1 year ago

      how it will dynamically update evvery day ?

      • v-dineshya's avatar
        v-dineshya
        Community Support
        1 year ago

        Hi Manasi25 ,

        Thanks for reaching out to the Microsoft fabric community forum.

         

        The DAX formula MAX('Sheet1'[Login Date]), which always picks the latest date (Login Date)  in the dataset. As new data is added, If new rows have a more recent date, the MAX function picks it up. The CALCULATETABLE condition filters the data to match this new latest date.

         

        If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
        Thanks and Regards