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 All,
I am getting the mentioned error while working with date columns .
To find latest updated date depending on different departments.
Tried using lastdate for find the same bit it gives the same error. is there any way or workaround to fix this.
Thank you
Solved! Go to Solution.
@rkumar,
A simple example for your reference. Right click your table, select "New Measure", then apply the following DAX.
Latest date=LASTDATE(Table[Date])
Regards,
Lydia
LASTDATE formulae is working fine when tested with some dummy data . It seems there is some other issue that we need to find in the data.
@rkumar,
How is the issue going? If you have solved the issue, please accept appropriate reply as answer to close this thread.
Regards,
Lydia
@rkumar,
A simple example for your reference. Right click your table, select "New Measure", then apply the following DAX.
Latest date=LASTDATE(Table[Date])
Regards,
Lydia
LASTDATE formulae is working fine when tested with some dummy data . It seems there is some other issue that we need to find in the data.
@rkumar,
How is the issue going? If you have solved the issue, please accept appropriate reply as answer to close this thread.
Regards,
Lydia
Can you post your formula and maybe some sample/fake data?
Hi Smoupre,
Thanks for the reply . LASTDATE formulae is working fine when tested with some dummy data . It seems there is some other issue that we need to find in the data. will work on same and if there are any further queries ,will revert you on the same .
Thankyou
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 |