Calculate days only for months that have applications

[Anonymous]

Hello,
I have two tables, one fact_table that contains the application_id and created_on (which is the date when the application was created) and one date_table(dimdate). I want to calculate the average of applications for the selected period. 
Avg = (nr of applications)/ (nr of days)
If I select period from March-July , I want the nr of days to be 62 for only the two months that have applications. 

application_id	created_on
id1	05.03.2021
id2	01.07.2021
id3	10.07.2021
id4	12.07.2021
id5	20.07.2021

[CNENFRNL]

Very easy one,

[Anonymous · Accepted solution]

Thank you so much
I added the column Month-Year from the Created_on date and than used it. 

[Jihwan_Kim]

Hi,

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

The slicer in my sample functions as, 

- even the startdate / enddate is in the middle of a certain month, it calculates from the beginning date of the month until the end date of the month.

Average measure: =
VAR selectedyears =
    VALUES ( Dates[Year] )
VAR selectedmonths =
    VALUES ( Dates[Month] )
VAR selectedperiod_in_date =
    SUMMARIZE (
        FILTER (
            ALL ( Dates ),
            Dates[Year]
                IN selectedyears
                && Dates[Month] IN selectedmonths
        ),
        Dates[Date]
    )
VAR numberofapplications =
    CALCULATE ( COUNTROWS ( 'Fact' ), 'Fact'[created_on] IN selectedperiod_in_date )
VAR selectedapplication_in_year =
    SUMMARIZE (
        ADDCOLUMNS (
            CALCULATETABLE (
                VALUES ( 'Fact'[created_on] ),
                'Fact'[created_on] IN selectedperiod_in_date
            ),
            "@year", YEAR ( 'Fact'[created_on] )
        ),
        [@year]
    )
VAR selectedapplication_in_month =
    SUMMARIZE (
        ADDCOLUMNS (
            CALCULATETABLE (
                VALUES ( 'Fact'[created_on] ),
                'Fact'[created_on] IN selectedperiod_in_date
            ),
            "@month", MONTH ( 'Fact'[created_on] )
        ),
        [@month]
    )
VAR countdays =
    CALCULATE (
        COUNTROWS ( Dates ),
        FILTER (
            ALL ( Dates ),
            Dates[Year]
                IN selectedapplication_in_year
                && Dates[Month] IN selectedapplication_in_month
        )
    )
RETURN
    numberofapplications / countdays