Calculate MTD based of Weeks passed in the month

[Anonymous]

Hi everyone,

I would like to calculated running MTD based on the week number.

Here is my table data:

So I would like a dax measure to calculate from the begining of the month ( now is august, week 31), until the last week in the month (today would be week 33, next week until week 34).

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pibx file.

It is for creating a measure.

expected measure: =
IF (
    HASONEVALUE ( Data[Week] ),
    CALCULATE (
        SUM ( Data[Weight] ),
        FILTER (
            ALL ( Data ),
            Data[Year] = MAX ( Data[Year] )
                && Data[Month] = MAX ( Data[Month] )
                && Data[Week] <= MAX ( Data[Week] )
        )
    )
)

[Anonymous]

Thank you @Jihwan_Kim 

Is working, but not as I want. It was my mistake to not write all the details.

I've added a date column in the table. Date(Year,Month, 1), the table beeing connected to a date table.

The report will be MTD filtered and I want the formula to work in a Card graph.