Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to Solution.
Days of month = day(eomonth([date],0))
Measure = divide(sumx(Table,Table[A] *Table[C]),sum(Table[B]))
Days of month = day(eomonth([date],0))
Measure = divide(sumx(Table,Table[A] *Table[C]),sum(Table[B]))
Perfect! It works. Thank you very much for this quick answer!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |