Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count Distinct Orders Raised Per Month Help

Hi,   I am new to Power BI so would really apprechiate some help with this question as it will help me progress my dashboard.   I have a table called JOBS that has 3 fields im interested in JOB N...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    No Problem Anonymous. Glad I could help.

     

    Please mark my reply as a solution to help others members of the community find answers that work. 😊

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous,

 

Assuming there is nothing odd with your data here, like duplicate Job Numbers, your measure should be reasonably straignt forward:

 

JobCount = COUNTX(Jobs, Jobs[Job_Number])

 

You can then use this alongside your Calendar[Date] field to summarise by Year/Quarter/Month/Day.

 

Cheers,

Andy

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Anonymous that makes sense now and works as i expected it.

     

    You many see some more help requests if the future as i familiarise myself with Power BI

     

    Thanks again

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      No Problem Anonymous. Glad I could help.

       

      Please mark my reply as a solution to help others members of the community find answers that work. 😊