Number of days of each months

[cosminc]

Hi,

i have a calendar 1 jan 2017 till 31 dec 2019 connected with a source which is split by months, but also i created a fake date - as first date of each month-year to make connection with calendar

now i need for a measure to count days in a graph depending of year and months selection

so if i select jan-feb 2019 i need to have 59 (31+28)

if the graph is split by months, i need to have for jan 31 and feb 28

Now count return only 1 for a month, probably due to fake date from source

Thanks,

Cosmin

[v-cherch-msft · Accepted solution]

Hi @cosminc 

You may add the YearMonth column for your calendar table and fake table.Then link them in relationship.Use date hierarchy for date column to expend the graph.

YearMonth = FORMAT('Calendar'[Date],"MMM YYYY")

Regards,

Cherie

[cosminc]

Hi

if i apply your solution there will be many to many relationship; on my base i have thousands of each month-year

Thanks,

Cosmin

[v-cherch-msft]

Hi @cosminc 

You may also delete the fake data table and just use calendar table's YearMonth column as slicer.If it is not your case,please share your sample data which could reproduce your scenario and your desired output.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Cherie

[cosminc]

my question was regarding that it will be a relationship many to many between the 2 bases - calendar and source

is it ok?

thanks,

Cosmin