Forum Discussion
Order Report (DAX Expression Help)
Have a SQL query that pulls order data every Monday. Have the data parameters set as: 12/31/2017 --> 12/31/2022. Is it best practice to have years in seperate tables? Or is the data fine bei...
Hello!! What kind of problems do You have when you use those measures??
When you work with time intelligence and you have to use measures like MTD or YTD You have to use time table (another way is build your own measures all in the dame table bit this is not efficient).
Regards
When you work with time intelligence and you have to use measures like MTD or YTD You have to use time table (another way is build your own measures all in the dame table bit this is not efficient).
Regards
Having troubles writing the measure with DAX.
Would you need a measure for each of the following: total orders 2018, total orders 2019, total orders 2020? And then use those measures in your variance measure?
Should I have a different query connection for each year? Each years has it's own table?
- The Best aproach to solve this kind of problems, is use just one table with all your data and share the metrics in diferents years (one metric for 2018, another for 2019 and the last for 2020). Finally You can get the variance using the diferents metric that you develop.
Regards!!