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.
Hi,
On the example below for Type 'Parts' there are 24 distinct dates for February (the dates are not all shown in this screen shot)
I would like to divide 'parts month target' by 24 to give me a 'daily target', so 50000/24.
There are more months in the table.
Is this possible using DAX?
Thanks
@Jay0610 ,
divide(Sum(Target[Target]), calculate(distinctcount(Table[Part]), allexcept(Table[Month Year]) ))
Thank you. 'Parts' is not a column but a possible value of the 'Type' column. I guess I can amend the calculation to include a filter?
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 |
---|---|
110 | |
101 | |
76 | |
64 | |
63 |
User | Count |
---|---|
141 | |
104 | |
101 | |
80 | |
67 |