Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I have a data source table that contains a weekly snapshot of project statuses. The table udates every Tuesday morning and appends with the latest updates. Each row of data includes a field with the update date.
Here's a simplified view of the source data:
Using the source data, I woudl like to create a new table that looks something like this, so I can track and report weekly changes to key project status fields.
Does anyone have any suggestions on the best way to tackle this? I've tried a couple solutions in Power Query, and a couple using DAX to create a virtual table, but just can't make it work. Any detailed suggestions you can offer for a Power Query or DAX solution would be much appreciated!
Solved! Go to Solution.
Hi
On the second pic you missed a ) to close the calculate function before the coma
But it does no explain everything. I have put your table name and fields names in the formula try it because here it still working well.
the new code you can copy
Hi
On the second pic you missed a ) to close the calculate function before the coma
But it does no explain everything. I have put your table name and fields names in the formula try it because here it still working well.
the new code you can copy
Thanks again @Anonymous ! I was able to drop your new code version in, and got the expected results! You are my hero for today!
Hi Benx, No problem happy for you. Have a nice day
Hello,
I have created a table==> Feuil1
and then I create a new table in Pwbi
Try it and tell me if it works.
@Anonymous Thanks so much for providing this example. I really appreciate your efforts! I have tried to implement it this morning, but I'm running into a few errors:
First, it doesn't like the IF expressions for the Change columns:
When I comment those lines out, I then get a error in line 16:
Any thoughts on what's going on?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
98 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |