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.
How do you calculate the average of [wholds] in the month? Activity date is connected to a date table.
Idealy, Id like to be able to know how many [wholds] a Sales rep made per day based off the number of days in the month.
Essentially it would be the disctinct count of wholds in the month divided by the number of days in the month, and I could put it into a matrix/table that would know which month the calculation corresponds to.
Wholds | Activity Date |
random numbers | 04-10-22 |
random numbers | 04-12-22 |
random numbers | 03-06-22 |
random numbers | 02-28-22 |
Solved! Go to Solution.
Hi @Anonymous
You can use
DIVIDE ( TableName[Wholds], COUNTROWS ( 'VALUES ( "Date'[Date] ) ) )
Hi @Anonymous ,
Please check the formula.
Meaasure =
VAR count_wholds =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Wholds] ),
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[Activity Date].[Year] = SELECTEDVALUE ( 'calendar'[Date].[Year] )
&& 'Table'[Activity Date].[Month] = SELECTEDVALUE ( 'calendar'[Date].[Month] )
)
)
RETURN
count_wholds / COUNTROWS ( 'calendar' )
Best Regards,
Jay
It did not work, I take it 'calendar' is the calendar table I have attached to the activity date.
Hi @Anonymous
You can use
DIVIDE ( TableName[Wholds], COUNTROWS ( 'VALUES ( "Date'[Date] ) ) )
This worked if the columns in the matrix are from the Date/Calendar table used and not from the Date from the Datatable.
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 |
---|---|
42 | |
21 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |