title: Power Query or DAX - Count number of times a value is present in a column
body: <p>I have a table and column A has IDs. I would like to count how many times each ID is present in the column so it would hopefully look something like this:</p>
  
  <p>Column A IDs    Column B Count
  1               1
  12              4
  10              1
  12              4
  12              4
  36              2
  36              2
  12              4</p>
  
  <p>I know how to do this in Excel but I am trying to do this in Power Query and/or Power Pivot.</p>
  
  <p>Please help!</p>