Solved: Re: I need to display Current Month and Last month...

Anonymous · ‎12-31-2021

I need to display Current Month and Last month as text in table but i get only Current month as text but i am not getting Last Month as text in table but coding doesn't shows error

mahoneypat · ‎12-31-2021

You are just subtracting 1 day from TODAY(). Replace TODAY()-1 with EOMONTH(TODAY(), -1) instead.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

mahoneypat · ‎12-31-2021

You are just subtracting 1 day from TODAY(). Replace TODAY()-1 with EOMONTH(TODAY(), -1) instead.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Anonymous · ‎01-16-2022

@mahoneypat Yes now it is working thanku so much

I need to display Current Month and Last month as text in table

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024