Forum Discussion
Add Column Last Completed Month YTD
Hi mclawler
What is the issue with your fornula? Try this
Column =
Var _M = month(today())
Var _Y = year(today())
Return
IF(month([Date])<_M&&year([Date])=_Y,1,0)If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn | Twitter | Blog | YouTube
mclawler- Check this out.
LastCompletedMonthYTD = IF ( YEAR ( YourTable[Date] ) = YEAR ( TODAY () ) && MONTH ( YourTable[Date] ) = MONTH ( EOMONTH ( TODAY (), -1 ) ), 1, 0 )If this post helps to find solution would be happy if you could mark my post as a solution and give it a thumbs up
Best regards
Manoj Nair
Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/
mclawler- Check this out.
LastCompletedMonthYTD =
IF (
YEAR ( YourTable[Date] ) = YEAR ( TODAY () )
&& MONTH ( YourTable[Date] ) = MONTH ( EOMONTH ( TODAY (), -1 ) ),
1,
0
)If this post helps to find solution would be happy if you could mark my post as a solution and give it a thumbs up
Best regards
Manoj Nair
Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/
Thank you, your DAX worked as well!!
mclawler-Hi, If the responses provided accurately address the question you posed, it's feasible to select both of them as accepted answers in a Power BI Community post. Choice is yours. 😉