Forum Discussion
AVERAGEX Function PowerBI
Hello @Amit, @Greg , @tamerj1 , @lbendlin @amitchandak , @olgad , @Sahir_Maharaj , @FreemanZ , @tamerj1 , @Greg_Deckler I was able to get the Average Jobs Per Hour Trend for each of the hou...
Hi,
Share some data, explain the question and show the expected result.
Hello Ashish_Mathur
The main question is how to find the Average Count of Distinct Jobs Per Hour for each of the hours in the X-axis starting from 0, 1, 2,..all the way to 23, filtered by date. Y-axis is the Distinct Count of Jobs.
Here is how the sample dataset looks like:
When I try to find the Average Count of Distinct Jobs Per Hour for each of the hours filtered by different date ranges, I am not getting correct answer. For example, for the month of April, I am getting answers like 65 or 1888 which does not make sense. I should get something like 3.5 etc..
Do you have any idea what DAX code shall I write to fix this issue?