Calculating with Days out of Date

[Pfoerster]

Hello,

the target is to calculate the average "Days on Stock" and to show it as a graph. Therefore, I need

a) Average Stock per month

b) Outbound per Month

c) Days of the Month

a) and b) is already available in my file. For c), I have a column with the first of a month (January 2020 = 01.01.2020). In Excel, where I build up an older version of that KPI, I calculate the amount of Days of January out of the Date. So, the formular for the 01.01.2020 is delivering me 31 (this is the formular: DAY(DATE(YEAR(cell of 01.01.2020);Month(cell of 01.01.2020)+1;1)-1)

Is there any equivalent in Power BI? So that I can buid up the KPI as:

(a) * c) ) / b)

[amitchandak · Accepted solution]

@Pfoerster ,

Days of month = day(eomonth([date],0))

Measure  = divide(sumx(Table,Table[A] *Table[C]),sum(Table[B]))

[Pfoerster]

Perfect! It works. Thank you very much for this quick answer!