title: Previous month value and previous year value for several categories in PowerBI
body: <p>I have the rawdata:</p>
  <pre><code>Monat       TX   DA    UA
  01.12.2021  1    10     1000
  01.11.2021  100  5       2000
  01.10.2021   20  5       3000
  ...
  01.12.2020  30   10     4000
  </code></pre>
  <p>in PowerQuery.</p>
  <p>How can I get the previous month and previous year values for all my categories in a smart way? I am searching for the output (if i select the filter for example month: 12.2021):</p>
  <pre><code>Category   This Year   Previous Month   Previous Year
  TX         1            100              30
  DA         10            5              10
  CA        1000         2000             4000
  
  </code></pre>