Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |