Formula for the current month

[Syndicate_Admin]

Hello!

There are formulas for the previous month (last month), last three months, next month... but is there a formula for the current month?

That is, I need to indicate the sales number of the current month and I can not find a way to do it.

Can you tell me the formula, please?

Thank you!

[v-binbinyu-msft]

Hi @Syndicate_Admin ,

Please try below dax formula

Current date =
IF ( MONTH ( 'CALENDAR'[Date] ) = MONTH ( TODAY () ), "S", "N" )

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shreeram04]

Hi @Syndicate_Admin,

Please find the below link for your reference.

https://community.powerbi.com/t5/Desktop/CURRENTMONTH/m-p/8673#M1493

If I resolve your problem Mark it as a solution and give kudos.

Thanks,

[Syndicate_Admin]

@Syndicate_Admin

Hello!

None of the solutions proposed in the post you have passed me solves my problem.

For example, for the current date, I have this formula in the Calendar table.

Current date = IF('CALENDAR'[Date] = TODAY(), "S", "N")

I want the same thing but with the current month, that in the days of September I get an "S".

Thank you and greetings!

[Syndicate_Admin · Accepted solution]

The DAX formula that has served me is this:

Current Month = IF(format([date],"YYYYMM")-format(today(),"YYYYMM"),"Other Months","Current Month")