Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good fellows, I hope you can help me.
I'm trying to calculate the variation month by month with the following measure:
However, I get the following error:
and as you can see, the data in the column, is date-type:
In advance thank you very much for all the help you can give me
Solved! Go to Solution.
Hi @Syndicate_Admin ,
Which connection mode does the data source you connect to adopt? For the DATEADD function, if it is in the Direct query mode, there may be performance problems, leading to errors.
Here is the reference document link:DATEADD function (DAX) - DAX | Microsoft Docs
Please make sure to use this function correctly and change the connection mode before trying again. If the problem is still not resolved, please let me know immediately, looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
Which connection mode does the data source you connect to adopt? For the DATEADD function, if it is in the Direct query mode, there may be performance problems, leading to errors.
Here is the reference document link:DATEADD function (DAX) - DAX | Microsoft Docs
Please make sure to use this function correctly and change the connection mode before trying again. If the problem is still not resolved, please let me know immediately, looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I am not sure how your data model looks like, but in my opinion, you need to have dim-date table.
And then, please try to write something like below.
Variations =
VAR current_value =
SUM ( factpagmb[valor facturado] )
VAR previous_value =
CALCULATE (
SUM ( factpagmb[valor facturado] ),
DATEADD ( 'your dim-date table'[date column], -1, MONTH )
)
RETURN
DIVIDE ( current_value - previous_value, current_value )
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Syndicate_Admin , Dateadd work on date.
so [Date].mes is not correct.
Also, prefer to date table in such case
example
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
if needed you can use date as date add
https://www.youtube.com/watch?v=9qiRivlBv8w
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |