Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Automatically Select and update latest four columns to data table

Hi, I want to update the latest four columns of data automatically on my dashboard. When I update the next date to my excel data base dashboard should select the latest four data columns and publish...
  • onurbmiguel_'s avatar
    onurbmiguel_
    3 years ago

    hi again 

    i have creat 2 example in power query: 

     

    Example 1:

     

    example 2:

     

     

    you can use the same link to view the pbix. 

     

    Best regards

    Bruno Costa | Responsive Resident

     

    Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

    Take a look at the blog: PBI Portugal