CODEWITHSUNDEEP
powerbidaxpowerbi-embedded
Serdia
Serdia

Reputation: 4418

How to get the first day of current month measure with Year parameter in Power BI?

Seems like it should be very simple, but I still couldn't fine the way to get the first day of current month having parameter "Year"

So if parameter year 2018 - I need May 1,2018

if parameter year 2017 - need May 1, 2017

etc.

I tried to use DATE function, but the year will be dynamic.

How simply choose the first day of the month?

Thanks

Upvotes: 3

Views: 7225

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

I'm not sure how your year parameter is set up, but how about something along these lines?

FirstDayOfCurrentMonth = DATE([Year Parameter], MONTH(TODAY()), 1)

Upvotes: 6

Related Questions