Forum Discussion
Solved
Should I split tables by year?
Hi, I am starting from scratch my dataset and have a common structure of: Order lines Delivery note lines Invoice line since many years ago. I was wondering if it makes sense to split thos...
jmvidal I am doing this with transaction data: 2015 to 2019 data is static and then 2020 data is refreshed. Then I use the UNION command. It makes the data refresh much faster.
Hi jmvidal ,
Yes, you can create a DAX using the "union" function. If you are a power Bi premium user, you can use "incremental refresh"
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, I''l be trying UNION.
Not a premium user yet.