Forum Discussion
Solved
Power Bi current month formula error
my current formula is not picking up all the data it should be. Any advice?
Not sure what all the formula is not picking up. The MONTH() function take in a Date "2023-08-01" not just a number 08. I think just putting an Integer just returns a 1.
Example:MonthMeasure =VAR CurrentMonth = MONTH("2023-04-01")Return CurrentMonth
This will return 4 if that is what is needed
3 Replies
Not sure what all the formula is not picking up. The MONTH() function take in a Date "2023-08-01" not just a number 08. I think just putting an Integer just returns a 1.
Example:MonthMeasure =VAR CurrentMonth = MONTH("2023-04-01")Return CurrentMonth
This will return 4 if that is what is neededThankyou so much! I'm a new user so still trying to get my head around the formulas
No problem, I am pretty new myself. Check out https://dax.guide/ they have great examples and help me when I feel like I am using a function incorrectly.
