Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I am trying to create a measure to calculate the variation between 2 years with the following measure:
Expenses variation =
Var CurrentExpenses = TOTALYTD(SUM(Sales[Sales]);'Calendar table'[Sales])
Var PreviousExpenses = CALCULATE(TOTALYTD(SUM(Sales[Sales]);'Calendar table'[Sales]);DATEADD('Calendar table'[Sales];-12;MONTH))
Return
(CurrentExpenses-PreviousExpenses)/PreviousExpenses
But I got the following error message:
The relationship between both tables is the following one:
How can I solve that?
Thanks in advance.
Regards.
Solved! Go to Solution.
Hi @v-janeyg-msft,
Thank you for your answer.
I was creating a simple data and I have found were the problem was.
I had a not activated relationship between Calendar table [Year] and another table with a both direction filter. When I changed that into single direction filter the problem was solved.
Regards.
Hi, @PwrBI01
Generally speaking, it is caused by discontinuous data or incorrect relationship, Please check it.
If it doesn't help, I think you need to provide a sample file,then we can judge.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @PwrBI01
The date using the time intelligence function must be continuous. Please check it.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-janeyg-msft,
Thank you for your answer.
I was creating a simple data and I have found were the problem was.
I had a not activated relationship between Calendar table [Year] and another table with a both direction filter. When I changed that into single direction filter the problem was solved.
Regards.
@PwrBI01 , Mark Calendar table as a date table, That will check for any issue with noncontinuous dates. Right-click on the table there is an option
Also, Try like
CALCULATE(TOTALYTD(SUM(Sales[Sales]);DATEADD('Calendar table'[Sales];-12;MONTH)))
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |