Creating DAX with number of days in months

[Anonymous]

Hi all,

I need to create the following formula into DAX = accounts receivable at month end/3 months total sales/# of days in 3 months

So, for example, for March, it will be = March AR / Jan - Mar sales / Jan - Mar number of days

I am able to create the following DAX:

DIVIDE(

        CALCULATE(SUM('A/R'[Amount]), 'A/R'[Date] = "2022-03-01"),

            SUM(Sales[Jan]) + SUM(Sales[Feb]) + SUM(Sales[Mar]))

What I'm having problem with is to incorporate the number of days. 

I created a date table:

But having problem in creating the DAX that works 

Created the following but it doesn't work 

DIVIDE(

        CALCULATE(SUM('A/R'[Amount]), 'A/R'[Date] = "2022-03-01"),

            SUM(Sales[Jan]) + SUM(Sales[Feb]) + SUM(Sales[Mar]),

            CALCULATE((COUNT('Calendar'[MonthYearNumber] = "22 01") || COUNT('Calendar'[MonthYearNumber] = "22 02") || COUNT('Calendar'[MonthYearNumber] = "22 03"))

    ))

Any chance someone can point me to the right direction?

Thanks!!

[amitchandak]

@Anonymous , try like

DIVIDE(
CALCULATE(SUM('A/R'[Amount]), 'A/R'[Date] = "2022-03-01"),
SUM(Sales[Jan]) + SUM(Sales[Feb]) + SUM(Sales[Mar]),
CALCULATE((COUNT('Calendar'[MonthYearNumber] = "22 01") + COUNT('Calendar'[MonthYearNumber] = "22 02") + COUNT('Calendar'[MonthYearNumber] = "22 03"))
))

[Anonymous]

@amitchandak 

I created a measure just to calculate the number of days and the following measure works:

However, when I tried to incorporate this measure onto the other measure, it didn't work:

Any chance you can tell me what needs to be done here?

[Anonymous · Accepted solution]

I end up using 3 different measures. One measure (Measure1)  just to calculate the number of days, one measure (Measure2) to calculate AR/sales, and then another measure to calculate measure1/Measure2. 

[Anonymous]

@amitchandak 

I tried the following which does not work either:

Nor this one:

[Anonymous]

@amitchandak 

Received the following error message: