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.
Hi,
the function worked to count the URLs but now I want to do the same with the browsers and it gives me error, but I don´t know why.
What is the problem?
Thx
Solved! Go to Solution.
Hi @Anonymous ,
EARLIER is a DAX function that acts exclusively on row context, and its purpose is to create a reference to a column value on an outer loop of the evaluation of the expression. It is commonly used in calculated columns during nested row by row iterations.
And it also can be used in measure when there nested row context in measure like ADDCOLUMNS function. For more details, please refer to https://javierguillen.wordpress.com/2012/02/06/can-earlier-be-used-in-dax-measures/
And in your situation, are you creating a measure? Would you please try to use MAX() instead of EARLIER? If it doesn't work, please show us some sample data by onedrive for business that we can help you well.
If this post help, please consider accept it as the solution to help others find it more quickly.
Best Regard,
Dedmon Dai
Hi @Anonymous ,
EARLIER is a DAX function that acts exclusively on row context, and its purpose is to create a reference to a column value on an outer loop of the evaluation of the expression. It is commonly used in calculated columns during nested row by row iterations.
And it also can be used in measure when there nested row context in measure like ADDCOLUMNS function. For more details, please refer to https://javierguillen.wordpress.com/2012/02/06/can-earlier-be-used-in-dax-measures/
And in your situation, are you creating a measure? Would you please try to use MAX() instead of EARLIER? If it doesn't work, please show us some sample data by onedrive for business that we can help you well.
If this post help, please consider accept it as the solution to help others find it more quickly.
Best Regard,
Dedmon Dai
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 |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |