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 Everyone,
I've a date where I've a range for 2 years and in this range I want to change all the days to 1st of that month. How can I do that I am working with directquery.
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
The Direct query connection mode is very restrictive for DAX functions, in another word, most DAX statements may not be supported in this mode, hence your error above. The more recommended method for you is to write the relevant SQL statements directly when connecting to the data source, to present the data you need precisely to the desktop.
Best regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly .
Hi @Anonymous ,
The Direct query connection mode is very restrictive for DAX functions, in another word, most DAX statements may not be supported in this mode, hence your error above. The more recommended method for you is to write the relevant SQL statements directly when connecting to the data source, to present the data you need precisely to the desktop.
Best regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly .
Hi @Anonymous
You can use
EOMONTH ( TableName[Date], -1 ) + 1
Hi @tamerj1 ,
Thanks for responding.
I've checked "EOMONTH" but It does not work in directquery mode.
@Anonymous
Try
=
DATE ( YEAR ( TableName[Date] ), MONTH ( TableName[Date] ), 1 )
No luck with this one as well.
@Anonymous
Have tryed creating it as a measure instead of a column? is this a valid option fro your case?
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 |
---|---|
42 | |
21 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |