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 everybody, I'm new to the DAX language, and I'm trying to create a DAX query to get the last day of each month in my dataset. The problem is that the last day isn't always correct; for example, January ends up on the 30th instead of the 31st. Once I find the last day, I need to assign "1" and "0" to all the other days of the month. I tried using EOMONTH, but it automatically creates the last day even when it's not present in the dataset. Thank you in advance!
Solved! Go to Solution.
Hi @glamanna
Please use EOMONTH DAX
Follow guide
https://dax.guide/eomonth/
https://learn.microsoft.com/en-us/dax/eomonth-function-dax
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Hi @glamanna
Please use EOMONTH DAX
Follow guide
https://dax.guide/eomonth/
https://learn.microsoft.com/en-us/dax/eomonth-function-dax
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
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 |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |