Determine number of days in month

[kfschaefer]

How do I determine the number of days in a month for each mtd to calculated the Target value?

[kfschaefer]

I need to calcuate the Target value per month and this would be determined by the number of days in each month

Looking for the correct syntax - 

if Jan = 31 then target/31 for the target value.

How do I determine the begin and end dates of each month and the number of days within each month?

[Greg_Deckler]

You could create a separate "Month" table like:

Month,Days
January,31
February,28
March,31

etc. and then create a measure to sum the [Days] column.

Not entirely sure what you are going for, a little context and data would help.

[sdjensen]

If you have a date table containing all the dates you should be able to create a measure that countrows on you date value this should return the number of days.

[kfschaefer]

is there dax code to create such a table and how do I implent it?

[sdjensen]

Loads of examples on the web on how to create a date table with power query. Just need a little googling. You could try this page https://www.powerquery.training/portfolio/dynamic-calendar-table/

[kfschaefer]

thanks for the suggestion , however, I do I do it in DAX?

I have a field called createDate (dates)  How do I use this field in an existing PowerBI Query to count the rows of days per each month worth of data?

[Greg_Deckler]

Right, in Desktop, use an Enter Data query to build your Month table. Then in your existing table in Desktop create a new column in your data model with a formula like:

MonthName = FORMAT([createDate],"MMMM")

Relate the two tables on the MonthName columns and create your measure.

[arify]

Alternatively, in M you can use Date.DaysInMonth

https://msdn.microsoft.com/en-us/library/mt260645.aspx

Date.DaysInMonth( DateTime.FromText("2012-03-01")) equals 31

[kfschaefer]

what is the correect syntax for count(datez)????

[sdjensen]

On my phone right now but it should be something like this. Let's say you have a table containing all your dates that is called dates and you have a column containing all the dates called dateskey.

Number of days = countrows(dates, dates[dateskey])