Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
FrankWoody
Helper I
Helper I

Power Challenge

Hello everyone, I hope you are all well.
I'm developing a project that I need to track the progress of my activities. The connection to my database takes place in real time directly from Ms planner, to do this monitoring so I thought of the following method.
1st I have a table that connects me directly with planner. So this is tb1.
2nd I duplicated the tb1 and created the tb2, in the tb2 I disabled the update so that it would serve as a history that I can use to compare the progress of the tb1.
3rd However, it may be possible to add new tasks on tb1 that I don't have on tb2, so I need to add this information on tb2 and save this information in it for the next updates.
I've thought about using dax functions to create custom tables, but it still didn't work out, I wanted to know if it's possible to do this manipulation with Dax or Powerquery. Share ideas and methods I'm open to suggestions Thank you all.

Vijay_A_Verma
@Vijay_A_Verma 

1 ACCEPTED SOLUTION

Hi @FrankWoodyblue ,

 

I think you may have to use R/Python to export data as snapshot of historical data when the data source is refreshed.

Schedule Automated Data Exports from Power BI using a simple R/Python Script 

 

Best Regards,
Winniz

 

View solution in original post

4 REPLIES 4
PaulMan
New Member

For assistance please. 

 

Im new user of power bi and I can't seem to find the a way to resolve the issue in transforming a data. 

 

So I have worked on some datas from a work laptop, and i wish to continue the work from my home laptop. All my data are in one xls sheeet which has a different tabs. When i open the file from my home laptop, it does not read the source. 

 

Thanks in advance.

FrankWoodyblue
Frequent Visitor

This really helps, however, when you bring up a tasks D, value 6. when the next update occurs and there is some change in the Value of D, I won't be able to track what the previous value was to make a comparison, you know?

Hi @FrankWoodyblue ,

 

I think you may have to use R/Python to export data as snapshot of historical data when the data source is refreshed.

Schedule Automated Data Exports from Power BI using a simple R/Python Script 

 

Best Regards,
Winniz

 

v-kkf-msft
Community Support
Community Support

Hi @FrankWoody ,

 

Please use DAX to create a new table.

 

newtable2 =
UNION ( Table2, FILTER ( Table1, NOT Table1[task] IN VALUES ( Table2[task] ) ) )

Test results:
After updating the data source, Table 1:

vkkfmsft_0-1657679124451.png

Table 2:

vkkfmsft_1-1657679140230.png

newtable 2:

vkkfmsft_2-1657679176793.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors