How to ignore dd/mm/yyyy but not mm/yyyy?

[janislv]

I have a table with one value for the entire month. This table has an active relationship to the dd/mm/yyyy calendar. I'm trying to create a calculated column within a measure in which this month's value becomes the daily value for each date of that month.

Any ideas?

Date	Value	Expected value
01/01/2023	100	100
02/01/2023		100
03/01/2023		100
04/01/2023		100
05/01/2023		100

[janislv · Accepted solution]

The solution was simple.

1) took off the relationship

2)

var month_b = STARTOFMONTH('Calendar'[Date])

return CALCULATE(AVERAGE(Data[Value]),Data[month] = month_b)

[amitchandak]

@janislv , a Few ways, The table have a month  or assume only the start date month, Join it with the date table on the month start date 

Month Start = eomonth([Date],-1)+1 //A new column in date table, join this

Another way

Power BI Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-...