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.
All
I am stuck and would be grateful for any help.
I have two tables that only have 4 weeks of data at a time.
They both refresh every week and the oldest week's information is deleted.
I need to create a historical table with the shipment and order value information that will add the new week's information to it and not be affected by the weekly refresh.
Report date Order Product color
1-Aug 1 red
7-Aug 2 blue
13-Aug 3 white
15-Aug 4 black
16-Aug 5 yellow
Order Order Value
1 $6.50
2 $7.50
3 $8.50
4 $9.75
5 $10.00
Thanks in advance
-tj
Solved! Go to Solution.
@tjeffries , refer if this can help
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
@tjeffries , refer if this can help
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
thank helped 🙂 Thank you!
Hi @tjeffries
If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!
If not, please kindly elaborate more.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |