Forum Discussion

Manasi25's avatar
Manasi25
Icon for Helper II rankHelper 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 wh...
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

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
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
    Icon for Helper II rankHelper II
    1 year ago

    how it will dynamically update evvery day ?

    • v-dineshya's avatar
      v-dineshya
      Icon for Community Support rankCommunity 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

       

       

       

       

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

        Hi Manasi25 ,

        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