Forum Discussion

domiowa's avatar
domiowa
Frequent Visitor
8 years ago

Sum by month

Hi everyone, I have a problem to do something very simple on excel but so hard on power BI I have a project table with my project Name, starting date, excepted ending date and ending date So I'd l...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi domiowa,

 

Try out these two measues please. You also can check it out in this file.

Measure 1 =
SUMX (
    SUMMARIZE (
        'Project',
        'Project'[Project],
        Project[Starting Date],
        Project[EndingDate],
        "Months", DATEDIFF ( Project[Starting Date], Project[EndingDate], MONTH )
    ),
    IF ( [Months] = 1, 1, BLANK () )
)
Measure 2 =
CALCULATE (
    COUNTROWS ( 'Project' ),
    FILTER (
        'Project',
        MONTH ( 'Project'[EndingDate] ) - MONTH ( Project[Starting Date] )
            = 1
    )
)

Sum_by_month

 

Best Regards,

Dale