Forum Discussion

jmvidal's avatar
jmvidal
Icon for Helper II rankHelper II
6 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago
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.
  • jmvidal's avatar
    jmvidal
    Icon for Helper II rankHelper II
    6 years ago

    Thanks, I''l be trying UNION.

    Not a premium user yet.