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.
Dear BI users,
I can not see EARLIER function working rightly (like below captured image).
Could you please tell me my wrong on the use of EARLIER?
Actually, I am creating MoM measures following below article.
However, I found everytime the error message whenever any use of EARLIER function.
So, I just made a very simple measure and it also show the same error message
even the simple measure is just a example of an article
Sincerely,
Lee, Hong Gwoo
Solved! Go to Solution.
As BhaveshPatel said, EARLIER and EARLIEST are usually used in calculated column. I’d like to recommend this article to you. It should be able to make you understand them more clearly.
And EARLIER can also be used in DAX measure in some situations. You can take a look at this article.
Best Regards,
Herbert
As BhaveshPatel said, EARLIER and EARLIEST are usually used in calculated column. I’d like to recommend this article to you. It should be able to make you understand them more clearly.
And EARLIER can also be used in DAX measure in some situations. You can take a look at this article.
Best Regards,
Herbert
Thank you Herbert,
Yes it can be used in DAX Measures too but In that specific case, It was supposed to be used for calculated column.
Regards
Bhavesh
Hi
It seems to me that instead of creating a calculated column, you are creating a measure.
To Create a Calculated Column,
Go to the Table and Right Click, Select New Column and Put the same syntax in there.
This will give you the right results.
Regards,
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |