The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have the following DAX to calculate a value for the last day of the previous month.
Solved! Go to Solution.
Hi,
For your syntax, it seems there is a ) in the wrong position:
IF(SELECTEDVALUE ('Dates'[Date]))
Move the bolded ")" to the very end of your dax.
As for alternative dax try something with this kind of idea:
Proud to be a Super User!
Hi,
Place the IF in the beginning of your DAX e.g. IF(SELECTEDVALUE ( Dates[Date] ) ) = 1, BLANK(), [YTDFunded])
As a sidenote for last day of a month try using ENDOFMONTH function.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
@ValtteriN Thank you for your help!
What I am I doing incorrectly? With this DAX it is returning an error of 'incorrect syntax'
@ValtteriN Also thank you for your suggestion with ENDOFMONTH.
Is there a different DAX I should be using to get what I need instead with the ENDOFMONTH and the IF?
Hi,
For your syntax, it seems there is a ) in the wrong position:
IF(SELECTEDVALUE ('Dates'[Date]))
Move the bolded ")" to the very end of your dax.
As for alternative dax try something with this kind of idea:
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
57 | |
32 | |
20 | |
17 | |
15 |
User | Count |
---|---|
56 | |
31 | |
30 | |
24 | |
21 |