days number of each year-month

[cosminc]

Hi

is it posible starting from columns month no (1-12) and year to obtain a column with number of days of each year-month?

Year    Month  Days

2019     1           31

2019       2         28

2019        1        31

etc 

Thanks!

Cosmin

[v-piga-msft · Accepted solution]

Hi @cosminc,

If I understand your scenario correctly that you only have Year and Month column, you want to get the days based on the year and month columns?

If it is, we could achieve that in Power BI, please follow the steps below.

If your month and year columns are text type, you could create a custom column in query editor and then change the column to be date type.

=[Year]&"-"&[Month]

After Close&&Apply, you could create a calculated column with the formula below.

Days = DAY(EOMONTH([Date],0))

Here is the output.

Best Regards,

Cherry

[cosminc]

Hi

this is it

thanks!

Cosmin