Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I'm having a data where I need to compare MTD and last Years MTD based on country, and also that has to be on single Stacked bar chart. My calculations are listed below.
MTD = TOTALMTD([Total Complaints],pcfinalbi1000[planneddate])
Kindly help me regarding as I can't figure it out how to fix it.
@amitchandak @Ashish_Mathur @Jihwan_Kim @SpartaBI @johnt75
Solved! Go to Solution.
@Rimi_2095 impossible to say anything with the info supplied. It can be any kind of reason why you don't get the correct value. The reason for your error was what I said.
To work with time intelligence functions you must use a standard date table. To get the right result you need to write the right code, and it can be complex depending on the way the model is created. I really suggest go and read the pattern and see if you maybe you missed some important code or relationship.
@Rimi_2095 you can't use time intelligence functions on date columns from your fact table. You need to have a standard date table in your model (or use the auto date/time table functionality but this is not recommended for the long run).
Please read this pattern, it will also give you instructions on an example date table.
https://www.daxpatterns.com/standard-time-related-calculations/
Hi @SpartaBI
Thanks for your quick response.
I'm having one dim_date table as well.
Using same dax with date table is not showing accurate value that has to come with calculation.
So in that case what I should do as I need to compare on the basis of country and offcourse with correct outcome?
@Rimi_2095 impossible to say anything with the info supplied. It can be any kind of reason why you don't get the correct value. The reason for your error was what I said.
To work with time intelligence functions you must use a standard date table. To get the right result you need to write the right code, and it can be complex depending on the way the model is created. I really suggest go and read the pattern and see if you maybe you missed some important code or relationship.