topic display the average number of sick reports in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-the-average-number-of-sick-reports/m-p/1406693#M25965 <P><SPAN>Good morning all, </SPAN></P><P>&nbsp;</P><P><SPAN>I would like to see the total number of sickness reports from the table below, I am successful, however, I do not want the average number of sick reports from the year before, so that I can easily compare whether there are more or less than the year before</SPAN></P><P>&nbsp;</P><P><SPAN>This is the DX i`m use</SPAN></P><DIV><DIV><SPAN>Meting = </SPAN></DIV><DIV><SPAN>Calculate(</SPAN></DIV><DIV><SPAN>sum(Blad1[aantal]),</SPAN></DIV><DIV><SPAN>DATESINPERIOD(Blad1[datum], lastdate(Blad1[datum]),-12,month)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>/</SPAN></DIV><DIV><SPAN>calculate(DISTINCTCOUNT(Blad1[datum]),</SPAN></DIV><DIV><SPAN>DATESINPERIOD(Blad1[datum], lastdate(Blad1[datum]),-12,month)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>and this is my tabel.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>datumaantalmaandjaar</SPAN></SPAN> <TABLE><TBODY><TR><TD>zondag 14 maart 2021</TD><TD>&nbsp;</TD><TD>3</TD><TD>2021</TD></TR><TR><TD>zondag 21 maart 2021</TD><TD>&nbsp;</TD><TD>3</TD><TD>2021</TD></TR><TR><TD>zondag 28 maart 2021</TD><TD>&nbsp;</TD><TD>3</TD><TD>2021</TD></TR><TR><TD>zondag 4 april 2021</TD><TD>&nbsp;</TD><TD>4</TD><TD>2021</TD></TR><TR><TD>zondag 11 april 2021</TD><TD>&nbsp;</TD><TD>4</TD><TD>2021</TD></TR><TR><TD>zondag 18 april 2021</TD><TD>&nbsp;</TD><TD>4</TD><TD>2021</TD></TR><TR><TD>zondag 25 april 2021</TD><TD>&nbsp;</TD><TD>4</TD><TD>2021</TD></TR><TR><TD>zondag 2 mei 2021</TD><TD>&nbsp;</TD><TD>5</TD><TD>2021</TD></TR><TR><TD>zondag 9 mei 2021</TD><TD>&nbsp;</TD><TD>5</TD><TD>2021</TD></TR><TR><TD>zondag 16 mei 2021</TD><TD>&nbsp;</TD><TD>5</TD><TD>2021</TD></TR><TR><TD>zondag 23 mei 2021</TD><TD>&nbsp;</TD><TD>5</TD><TD>2021</TD></TR><TR><TD>zondag 30 mei 2021</TD><TD>&nbsp;</TD><TD>5</TD><TD>2021</TD></TR><TR><TD>zondag 6 juni 2021</TD><TD>&nbsp;</TD><TD>6</TD><TD>2021</TD></TR><TR><TD>zondag 13 juni 2021</TD><TD>&nbsp;</TD><TD>6</TD><TD>2021</TD></TR><TR><TD>zondag 20 juni 2021</TD><TD>&nbsp;</TD><TD>6</TD><TD>2021</TD></TR><TR><TD>zondag 27 juni 2021</TD><TD>&nbsp;</TD><TD>6</TD><TD>2021</TD></TR><TR><TD>zondag 4 juli 2021</TD><TD>&nbsp;</TD><TD>7</TD><TD>2021</TD></TR><TR><TD>zondag 11 juli 2021</TD><TD>&nbsp;</TD><TD>7</TD><TD>2021</TD></TR><TR><TD>zondag 18 juli 2021</TD><TD>&nbsp;</TD><TD>7</TD><TD>2021</TD></TR><TR><TD>zondag 25 juli 2021</TD><TD>&nbsp;</TD><TD>7</TD><TD>2021</TD></TR><TR><TD>zondag 1 augustus 2021</TD><TD>&nbsp;</TD><TD>8</TD><TD>2021</TD></TR><TR><TD>zondag 8 augustus 2021</TD><TD>&nbsp;</TD><TD>8</TD><TD>2021</TD></TR><TR><TD>zondag 15 augustus 2021</TD><TD>&nbsp;</TD><TD>8</TD><TD>2021</TD></TR><TR><TD>zondag 22 augustus 2021</TD><TD>&nbsp;</TD><TD>8</TD><TD>2021</TD></TR><TR><TD>zondag 29 augustus 2021</TD><TD>&nbsp;</TD><TD>8</TD><TD>2021</TD></TR><TR><TD>zondag 5 september 2021</TD><TD>&nbsp;</TD><TD>9</TD><TD>2021</TD></TR><TR><TD>zondag 12 september 2021</TD><TD>&nbsp;</TD><TD>9</TD><TD>2021</TD></TR><TR><TD>zondag 19 september 2021</TD><TD>&nbsp;</TD><TD>9</TD><TD>2021</TD></TR><TR><TD>zondag 26 september 2021</TD><TD>&nbsp;</TD><TD>9</TD><TD>2021</TD></TR><TR><TD>zondag 3 oktober 2021</TD><TD>&nbsp;</TD><TD>10</TD><TD>2021</TD></TR><TR><TD>zondag 10 oktober 2021</TD><TD>&nbsp;</TD><TD>10</TD><TD>2021</TD></TR><TR><TD>zondag 17 oktober 2021</TD><TD>&nbsp;</TD><TD>10</TD><TD>2021</TD></TR><TR><TD>zondag 24 oktober 2021</TD><TD>&nbsp;</TD><TD>10</TD><TD>2021</TD></TR><TR><TD>zondag 31 oktober 2021</TD><TD>&nbsp;</TD><TD>10</TD><TD>2021</TD></TR><TR><TD>zondag 7 november 2021</TD><TD>&nbsp;</TD><TD>11</TD><TD>2021</TD></TR><TR><TD>zondag 14 november 2021</TD><TD>&nbsp;</TD><TD>11</TD><TD>2021</TD></TR><TR><TD>zondag 21 november 2021</TD><TD>&nbsp;</TD><TD>11</TD><TD>2021</TD></TR><TR><TD>zondag 28 november 2021</TD><TD>&nbsp;</TD><TD>11</TD><TD>2021</TD></TR><TR><TD>zondag 5 december 2021</TD><TD>&nbsp;</TD><TD>12</TD><TD>2021</TD></TR><TR><TD>zondag 12 december 2021</TD><TD>&nbsp;</TD><TD>12</TD><TD>2021</TD></TR><TR><TD>zondag 19 december 2021</TD><TD>&nbsp;</TD><TD>12</TD><TD>2021</TD></TR><TR><TD>zondag 26 december 2021</TD><TD>&nbsp;</TD><TD>12</TD><TD>2021</TD></TR><TR><TD>zondag 2 januari 2022</TD><TD>&nbsp;</TD><TD>1</TD><TD>2022</TD></TR><TR><TD>zondag 9 januari 2022</TD><TD>&nbsp;</TD><TD>1</TD><TD>2022</TD></TR><TR><TD>zondag 16 januari 2022</TD><TD>&nbsp;</TD><TD>1</TD><TD>2022</TD></TR><TR><TD>zondag 23 januari 2022</TD><TD>&nbsp;</TD><TD>1</TD><TD>2022</TD></TR><TR><TD>zondag 30 januari 2022</TD><TD>&nbsp;</TD><TD>1</TD><TD>2022</TD></TR><TR><TD>zondag 6 februari 2022</TD><TD>&nbsp;</TD><TD>2</TD><TD>2022</TD></TR><TR><TD>zondag 13 februari 2022</TD><TD>&nbsp;</TD><TD>2</TD><TD>2022</TD></TR><TR><TD>zondag 20 februari 2022</TD><TD>&nbsp;</TD><TD>2</TD><TD>2022</TD></TR><TR><TD>zondag 27 februari 2022</TD><TD>&nbsp;</TD><TD>2</TD><TD>2022</TD></TR><TR><TD>zondag 6 maart 2022</TD><TD>&nbsp;</TD><TD>3</TD><TD>2022</TD></TR><TR><TD>zondag 13 maart 2022</TD><TD>&nbsp;</TD><TD>3</TD><TD>2022</TD></TR><TR><TD>zondag 20 maart 2022</TD><TD>&nbsp;</TD><TD>3</TD><TD>2022</TD></TR><TR><TD>zondag 27 maart 2022</TD><TD>&nbsp;</TD><TD>3</TD><TD>2022</TD></TR><TR><TD>zondag 3 april 2022</TD><TD>&nbsp;</TD><TD>4</TD><TD>2022</TD></TR><TR><TD>zondag 10 april 2022</TD><TD>&nbsp;</TD><TD>4</TD><TD>2022</TD></TR><TR><TD>zondag 17 april 2022</TD><TD>&nbsp;</TD><TD>4</TD><TD>2022</TD></TR><TR><TD>zondag 24 april 2022</TD><TD>&nbsp;</TD><TD>4</TD><TD>2022</TD></TR><TR><TD>zondag 1 mei 2022</TD><TD>&nbsp;</TD><TD>5</TD><TD>2022</TD></TR><TR><TD>zondag 8 mei 2022</TD><TD>&nbsp;</TD><TD>5</TD><TD>2022</TD></TR><TR><TD>zondag 15 mei 2022</TD><TD>&nbsp;</TD><TD>5</TD><TD>2022</TD></TR><TR><TD>zondag 22 mei 2022</TD><TD>&nbsp;</TD><TD>5</TD><TD>2022</TD></TR><TR><TD>zondag 29 mei 2022</TD><TD>&nbsp;</TD><TD>5</TD><TD>2022</TD></TR><TR><TD>zondag 5 juni 2022</TD><TD>&nbsp;</TD><TD>6</TD><TD>2022</TD></TR><TR><TD>zondag 12 juni 2022</TD><TD>&nbsp;</TD><TD>6</TD><TD>2022</TD></TR><TR><TD>zondag 19 juni 2022</TD><TD>&nbsp;</TD><TD>6</TD><TD>2022</TD></TR><TR><TD>zondag 26 juni 2022</TD><TD>&nbsp;</TD><TD>6</TD><TD>2022</TD></TR><TR><TD>zondag 3 juli 2022</TD><TD>&nbsp;</TD><TD>7</TD><TD>2022</TD></TR><TR><TD>zondag 10 juli 2022</TD><TD>&nbsp;</TD><TD>7</TD><TD>2022</TD></TR><TR><TD>zondag 17 juli 2022</TD><TD>&nbsp;</TD><TD>7</TD><TD>2022</TD></TR><TR><TD>zondag 24 juli 2022</TD><TD>&nbsp;</TD><TD>7</TD><TD>2022</TD></TR><TR><TD>zondag 31 juli 2022</TD><TD>&nbsp;</TD><TD>7</TD><TD>2022</TD></TR><TR><TD>zondag 7 augustus 2022</TD><TD>&nbsp;</TD><TD>8</TD><TD>2022</TD></TR><TR><TD>zondag 14 augustus 2022</TD><TD>&nbsp;</TD><TD>8</TD><TD>2022</TD></TR><TR><TD>zondag 21 augustus 2022</TD><TD>&nbsp;</TD><TD>8</TD><TD>2022</TD></TR><TR><TD>zondag 28 augustus 2022</TD><TD>&nbsp;</TD><TD>8</TD><TD>2022</TD></TR><TR><TD>zondag 4 september 2022</TD><TD>&nbsp;</TD><TD>9</TD><TD>2022</TD></TR><TR><TD>zondag 11 september 2022</TD><TD>&nbsp;</TD><TD>9</TD><TD>2022</TD></TR><TR><TD>zondag 18 september 2022</TD><TD>&nbsp;</TD><TD>9</TD><TD>2022</TD></TR><TR><TD>zondag 25 september 2022</TD><TD>&nbsp;</TD><TD>9</TD><TD>2022</TD></TR><TR><TD>zondag 2 oktober 2022</TD><TD>&nbsp;</TD><TD>10</TD><TD>2022</TD></TR><TR><TD>zondag 9 oktober 2022</TD><TD>&nbsp;</TD><TD>10</TD><TD>2022</TD></TR><TR><TD>zondag 16 oktober 2022</TD><TD>&nbsp;</TD><TD>10</TD><TD>2022</TD></TR><TR><TD>zondag 23 oktober 2022</TD><TD>&nbsp;</TD><TD>10</TD><TD>2022</TD></TR><TR><TD>zondag 30 oktober 2022</TD><TD>&nbsp;</TD><TD>10</TD><TD>2022</TD></TR><TR><TD>zondag 6 november 2022</TD><TD>&nbsp;</TD><TD>11</TD><TD>2022</TD></TR><TR><TD>zondag 13 november 2022</TD><TD>&nbsp;</TD><TD>11</TD><TD>2022</TD></TR><TR><TD>zondag 20 november 2022</TD><TD>&nbsp;</TD><TD>11</TD><TD>2022</TD></TR><TR><TD>zondag 27 november 2022</TD><TD>&nbsp;</TD><TD>11</TD><TD>2022</TD></TR><TR><TD>zondag 4 december 2022</TD><TD>&nbsp;</TD><TD>12</TD><TD>2022</TD></TR><TR><TD>zondag 11 december 2022</TD><TD>&nbsp;</TD><TD>12</TD><TD>2022</TD></TR><TR><TD>zondag 18 december 2022</TD><TD>&nbsp;</TD><TD>12</TD><TD>2022</TD></TR><TR><TD>zondag 25 december 2022</TD><TD>&nbsp;</TD><TD>12</TD><TD>2022</TD></TR><TR><TD>zondag 1 januari 2023</TD><TD>&nbsp;</TD><TD>1</TD><TD>2023</TD></TR><TR><TD>zondag 8 januari 2023</TD><TD>&nbsp;</TD><TD>1</TD><TD>2023</TD></TR><TR><TD>zondag 15 januari 2023</TD><TD>&nbsp;</TD><TD>1</TD><TD>2023</TD></TR><TR><TD>zondag 22 januari 2023</TD><TD>&nbsp;</TD><TD>1</TD><TD>2023</TD></TR><TR><TD>zondag 29 januari 2023</TD><TD>&nbsp;</TD><TD>1</TD><TD>2023</TD></TR><TR><TD>zondag 5 februari 2023</TD><TD>&nbsp;</TD><TD>2</TD><TD>2023</TD></TR><TR><TD>zondag 12 februari 2023</TD><TD>&nbsp;</TD><TD>2</TD><TD>2023</TD></TR><TR><TD>zondag 19 februari 2023</TD><TD>&nbsp;</TD><TD>2</TD><TD>2023</TD></TR><TR><TD>zondag 26 februari 2023</TD><TD>&nbsp;</TD><TD>2</TD><TD>2023</TD></TR><TR><TD>zondag 5 maart 2023</TD><TD>&nbsp;</TD><TD>3</TD><TD>2023</TD></TR><TR><TD>zondag 12 maart 2023</TD><TD>&nbsp;</TD><TD>3</TD><TD>2023</TD></TR><TR><TD>zondag 19 maart 2023</TD><TD>&nbsp;</TD><TD>3</TD><TD>2023</TD></TR><TR><TD>zondag 26 maart 2023</TD><TD>&nbsp;</TD><TD>3</TD><TD>2023</TD></TR><TR><TD>zondag 2 april 2023</TD><TD>&nbsp;</TD><TD>4</TD><TD>2023</TD></TR><TR><TD>zondag 9 april 2023</TD><TD>&nbsp;</TD><TD>4</TD><TD>2023</TD></TR><TR><TD>zondag 16 april 2023</TD><TD>&nbsp;</TD><TD>4</TD><TD>2023</TD></TR><TR><TD>zondag 23 april 2023</TD><TD>&nbsp;</TD><TD>4</TD><TD>2023</TD></TR><TR><TD>zondag 30 april 2023</TD><TD>&nbsp;</TD><TD>4</TD><TD>2023</TD></TR><TR><TD>zondag 7 mei 2023</TD><TD>&nbsp;</TD><TD>5</TD><TD>2023</TD></TR><TR><TD>zondag 14 mei 2023</TD><TD>&nbsp;</TD><TD>5</TD><TD>2023</TD></TR><TR><TD>zondag 21 mei 2023</TD><TD>&nbsp;</TD><TD>5</TD><TD>2023</TD></TR><TR><TD>zondag 28 mei 2023</TD><TD>&nbsp;</TD><TD>5</TD><TD>2023</TD></TR><TR><TD>zondag 4 juni 2023</TD><TD>&nbsp;</TD><TD>6</TD><TD>2023</TD></TR><TR><TD>zondag 11 juni 2023</TD><TD>&nbsp;</TD><TD>6</TD><TD>2023</TD></TR><TR><TD>zondag 18 juni 2023</TD><TD>&nbsp;</TD><TD>6</TD><TD>2023</TD></TR><TR><TD>zondag 25 juni 2023</TD><TD>&nbsp;</TD><TD>6</TD><TD>2023</TD></TR><TR><TD>zondag 2 juli 2023</TD><TD>&nbsp;</TD><TD>7</TD><TD>2023</TD></TR><TR><TD>zondag 9 juli 2023</TD><TD>&nbsp;</TD><TD>7</TD><TD>2023</TD></TR><TR><TD>zondag 16 juli 2023</TD><TD>&nbsp;</TD><TD>7</TD><TD>2023</TD></TR><TR><TD>zondag 23 juli 2023</TD><TD>&nbsp;</TD><TD>7</TD><TD>2023</TD></TR><TR><TD>zondag 30 juli 2023</TD><TD>&nbsp;</TD><TD>7</TD><TD>2023</TD></TR><TR><TD>zondag 6 augustus 2023</TD><TD>&nbsp;</TD><TD>8</TD><TD>2023</TD></TR><TR><TD>zondag 13 augustus 2023</TD><TD>&nbsp;</TD><TD>8</TD><TD>2023</TD></TR><TR><TD>zondag 20 augustus 2023</TD><TD>&nbsp;</TD><TD>8</TD><TD>2023</TD></TR><TR><TD>zondag 27 augustus 2023</TD><TD>&nbsp;</TD><TD>8</TD><TD>2023</TD></TR><TR><TD>zondag 3 september 2023</TD><TD>&nbsp;</TD><TD>9</TD><TD>2023</TD></TR><TR><TD>zondag 10 september 2023</TD><TD>&nbsp;</TD><TD>9</TD><TD>2023</TD></TR><TR><TD>zondag 17 september 2023</TD><TD>&nbsp;</TD><TD>9</TD><TD>2023</TD></TR><TR><TD>zondag 24 september 2023</TD><TD>&nbsp;</TD><TD>9</TD><TD>2023</TD></TR><TR><TD>zondag 1 oktober 2023</TD><TD>&nbsp;</TD><TD>10</TD><TD>2023</TD></TR><TR><TD>zondag 8 oktober 2023</TD><TD>&nbsp;</TD><TD>10</TD><TD>2023</TD></TR><TR><TD>zondag 15 oktober 2023</TD><TD>&nbsp;</TD><TD>10</TD><TD>2023</TD></TR><TR><TD>zondag 22 oktober 2023</TD><TD>&nbsp;</TD><TD>10</TD><TD>2023</TD></TR><TR><TD>zondag 29 oktober 2023</TD><TD>&nbsp;</TD><TD>10</TD><TD>2023</TD></TR><TR><TD>zondag 5 november 2023</TD><TD>&nbsp;</TD><TD>11</TD><TD>2023</TD></TR><TR><TD>zondag 12 november 2023</TD><TD>&nbsp;</TD><TD>11</TD><TD>2023</TD></TR><TR><TD>zondag 19 november 2023</TD><TD>&nbsp;</TD><TD>11</TD><TD>2023</TD></TR><TR><TD>zondag 26 november 2023</TD><TD>&nbsp;</TD><TD>11</TD><TD>2023</TD></TR><TR><TD>zondag 3 december 2023</TD><TD>&nbsp;</TD><TD>12</TD><TD>2023</TD></TR><TR><TD>zondag 5 januari 2020</TD><TD>2</TD><TD>1</TD><TD>2020</TD></TR><TR><TD>zondag 12 januari 2020</TD><TD>2</TD><TD>1</TD><TD>2020</TD></TR><TR><TD>zondag 19 januari 2020</TD><TD>2</TD><TD>1</TD><TD>2020</TD></TR><TR><TD>zondag 26 januari 2020</TD><TD>2</TD><TD>1</TD><TD>2020</TD></TR><TR><TD>zondag 2 februari 2020</TD><TD>2</TD><TD>2</TD><TD>2020</TD></TR><TR><TD>zondag 9 februari 2020</TD><TD>2</TD><TD>2</TD><TD>2020</TD></TR><TR><TD>zondag 16 februari 2020</TD><TD>2</TD><TD>2</TD><TD>2020</TD></TR><TR><TD>zondag 23 februari 2020</TD><TD>2</TD><TD>2</TD><TD>2020</TD></TR><TR><TD>zondag 1 maart 2020</TD><TD>2</TD><TD>3</TD><TD>2020</TD></TR><TR><TD>zondag 8 maart 2020</TD><TD>2</TD><TD>3</TD><TD>2020</TD></TR><TR><TD>zondag 15 maart 2020</TD><TD>2</TD><TD>3</TD><TD>2020</TD></TR><TR><TD>zondag 22 maart 2020</TD><TD>2</TD><TD>3</TD><TD>2020</TD></TR><TR><TD>zondag 29 maart 2020</TD><TD>2</TD><TD>3</TD><TD>2020</TD></TR><TR><TD>zondag 5 april 2020</TD><TD>4</TD><TD>4</TD><TD>2020</TD></TR><TR><TD>zondag 12 april 2020</TD><TD>4</TD><TD>4</TD><TD>2020</TD></TR><TR><TD>zondag 19 april 2020</TD><TD>4</TD><TD>4</TD><TD>2020</TD></TR><TR><TD>zondag 26 april 2020</TD><TD>4</TD><TD>4</TD><TD>2020</TD></TR><TR><TD>zondag 3 mei 2020</TD><TD>4</TD><TD>5</TD><TD>2020</TD></TR><TR><TD>zondag 10 mei 2020</TD><TD>2</TD><TD>5</TD><TD>2020</TD></TR><TR><TD>zondag 17 mei 2020</TD><TD>2</TD><TD>5</TD><TD>2020</TD></TR><TR><TD>zondag 24 mei 2020</TD><TD>2</TD><TD>5</TD><TD>2020</TD></TR><TR><TD>zondag 31 mei 2020</TD><TD>2</TD><TD>5</TD><TD>2020</TD></TR><TR><TD>zondag 7 juni 2020</TD><TD>2</TD><TD>6</TD><TD>2020</TD></TR><TR><TD>zondag 14 juni 2020</TD><TD>2</TD><TD>6</TD><TD>2020</TD></TR><TR><TD>zondag 21 juni 2020</TD><TD>8</TD><TD>6</TD><TD>2020</TD></TR><TR><TD>zondag 28 juni 2020</TD><TD>2</TD><TD>6</TD><TD>2020</TD></TR><TR><TD>zondag 5 juli 2020</TD><TD>2</TD><TD>7</TD><TD>2020</TD></TR><TR><TD>zondag 12 juli 2020</TD><TD>2</TD><TD>7</TD><TD>2020</TD></TR><TR><TD>zondag 19 juli 2020</TD><TD>2</TD><TD>7</TD><TD>2020</TD></TR><TR><TD>zondag 26 juli 2020</TD><TD>2</TD><TD>7</TD><TD>2020</TD></TR><TR><TD>zondag 2 augustus 2020</TD><TD>2</TD><TD>8</TD><TD>2020</TD></TR><TR><TD>zondag 9 augustus 2020</TD><TD>2</TD><TD>8</TD><TD>2020</TD></TR><TR><TD>zondag 16 augustus 2020</TD><TD>2</TD><TD>8</TD><TD>2020</TD></TR><TR><TD>zondag 23 augustus 2020</TD><TD>2</TD><TD>8</TD><TD>2020</TD></TR><TR><TD>zondag 30 augustus 2020</TD><TD>2</TD><TD>8</TD><TD>2020</TD></TR><TR><TD>zondag 6 september 2020</TD><TD>2</TD><TD>9</TD><TD>2020</TD></TR><TR><TD>zondag 13 september 2020</TD><TD>2</TD><TD>9</TD><TD>2020</TD></TR><TR><TD>zondag 20 september 2020</TD><TD>2</TD><TD>9</TD><TD>2020</TD></TR><TR><TD>zondag 27 september 2020</TD><TD>2</TD><TD>9</TD><TD>2020</TD></TR><TR><TD>zondag 4 oktober 2020</TD><TD>2</TD><TD>10</TD><TD>2020</TD></TR><TR><TD>zondag 11 oktober 2020</TD><TD>2</TD><TD>10</TD><TD>2020</TD></TR><TR><TD>zondag 18 oktober 2020</TD><TD>2</TD><TD>10</TD><TD>2020</TD></TR><TR><TD>zondag 25 oktober 2020</TD><TD>2</TD><TD>10</TD><TD>2020</TD></TR><TR><TD>zondag 1 november 2020</TD><TD>2</TD><TD>11</TD><TD>2020</TD></TR><TR><TD>zondag 8 november 2020</TD><TD>2</TD><TD>11</TD><TD>2020</TD></TR><TR><TD>zondag 15 november 2020</TD><TD>2</TD><TD>11</TD><TD>2020</TD></TR><TR><TD>zondag 22 november 2020</TD><TD>2</TD><TD>11</TD><TD>2020</TD></TR><TR><TD>zondag 29 november 2020</TD><TD>2</TD><TD>11</TD><TD>2020</TD></TR><TR><TD>zondag 6 december 2020</TD><TD>2</TD><TD>12</TD><TD>2020</TD></TR><TR><TD>zondag 13 december 2020</TD><TD>2</TD><TD>12</TD><TD>2020</TD></TR><TR><TD>zondag 20 december 2020</TD><TD>2</TD><TD>12</TD><TD>2020</TD></TR><TR><TD>zondag 27 december 2020</TD><TD>2</TD><TD>12</TD><TD>2020</TD></TR><TR><TD>zondag 3 januari 2021</TD><TD>2</TD><TD>1</TD><TD>2021</TD></TR><TR><TD>zondag 10 januari 2021</TD><TD>2</TD><TD>1</TD><TD>2021</TD></TR><TR><TD>zondag 17 januari 2021</TD><TD>2</TD><TD>1</TD><TD>2021</TD></TR><TR><TD>zondag 24 januari 2021</TD><TD>2</TD><TD>1</TD><TD>2021</TD></TR><TR><TD>zondag 31 januari 2021</TD><TD>2</TD><TD>1</TD><TD>2021</TD></TR><TR><TD>zondag 7 februari 2021</TD><TD>2</TD><TD>2</TD><TD>2021</TD></TR><TR><TD>zondag 14 februari 2021</TD><TD>2</TD><TD>2</TD><TD>2021</TD></TR><TR><TD>zondag 21 februari 2021</TD><TD>2</TD><TD>2</TD><TD>2021</TD></TR><TR><TD>zondag 28 februari 2021</TD><TD>2</TD><TD>2</TD><TD>2021</TD></TR><TR><TD>zondag 7 maart 2021</TD><TD>2</TD><TD>3</TD><TD><P>2021</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want that he looks 12 months back so the avarige of the last 12 months</P><P>&nbsp;</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><img /></P></DIV></DIV> Thu, 01 Oct 2020 07:41:44 GMT bastiaan2222 2020-10-01T07:41:44Z display the average number of sick reports https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-the-average-number-of-sick-reports/m-p/1406693#M25965 <P><SPAN>Good morning all, </SPAN></P><P>&nbsp;</P><P><SPAN>I would like to see the total number of sickness reports from the table below, I am successful, however, I do not want the average number of sick reports from the year before, so that I can easily compare whether there are more or less than the year before</SPAN></P><P>&nbsp;</P><P><SPAN>This is the DX i`m use</SPAN></P><DIV><DIV><SPAN>Meting = </SPAN></DIV><DIV><SPAN>Calculate(</SPAN></DIV><DIV><SPAN>sum(Blad1[aantal]),</SPAN></DIV><DIV><SPAN>DATESINPERIOD(Blad1[datum], lastdate(Blad1[datum]),-12,month)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>/</SPAN></DIV><DIV><SPAN>calculate(DISTINCTCOUNT(Blad1[datum]),</SPAN></DIV><DIV><SPAN>DATESINPERIOD(Blad1[datum], lastdate(Blad1[datum]),-12,month)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>and this is my tabel.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>datumaantalmaandjaar</SPAN></SPAN> <TABLE><TBODY><TR><TD>zondag 14 maart 2021</TD><TD>&nbsp;</TD><TD>3</TD><TD>2021</TD></TR><TR><TD>zondag 21 maart 2021</TD><TD>&nbsp;</TD><TD>3</TD><TD>2021</TD></TR><TR><TD>zondag 28 maart 2021</TD><TD>&nbsp;</TD><TD>3</TD><TD>2021</TD></TR><TR><TD>zondag 4 april 2021</TD><TD>&nbsp;</TD><TD>4</TD><TD>2021</TD></TR><TR><TD>zondag 11 april 2021</TD><TD>&nbsp;</TD><TD>4</TD><TD>2021</TD></TR><TR><TD>zondag 18 april 2021</TD><TD>&nbsp;</TD><TD>4</TD><TD>2021</TD></TR><TR><TD>zondag 25 april 2021</TD><TD>&nbsp;</TD><TD>4</TD><TD>2021</TD></TR><TR><TD>zondag 2 mei 2021</TD><TD>&nbsp;</TD><TD>5</TD><TD>2021</TD></TR><TR><TD>zondag 9 mei 2021</TD><TD>&nbsp;</TD><TD>5</TD><TD>2021</TD></TR><TR><TD>zondag 16 mei 2021</TD><TD>&nbsp;</TD><TD>5</TD><TD>2021</TD></TR><TR><TD>zondag 23 mei 2021</TD><TD>&nbsp;</TD><TD>5</TD><TD>2021</TD></TR><TR><TD>zondag 30 mei 2021</TD><TD>&nbsp;</TD><TD>5</TD><TD>2021</TD></TR><TR><TD>zondag 6 juni 2021</TD><TD>&nbsp;</TD><TD>6</TD><TD>2021</TD></TR><TR><TD>zondag 13 juni 2021</TD><TD>&nbsp;</TD><TD>6</TD><TD>2021</TD></TR><TR><TD>zondag 20 juni 2021</TD><TD>&nbsp;</TD><TD>6</TD><TD>2021</TD></TR><TR><TD>zondag 27 juni 2021</TD><TD>&nbsp;</TD><TD>6</TD><TD>2021</TD></TR><TR><TD>zondag 4 juli 2021</TD><TD>&nbsp;</TD><TD>7</TD><TD>2021</TD></TR><TR><TD>zondag 11 juli 2021</TD><TD>&nbsp;</TD><TD>7</TD><TD>2021</TD></TR><TR><TD>zondag 18 juli 2021</TD><TD>&nbsp;</TD><TD>7</TD><TD>2021</TD></TR><TR><TD>zondag 25 juli 2021</TD><TD>&nbsp;</TD><TD>7</TD><TD>2021</TD></TR><TR><TD>zondag 1 augustus 2021</TD><TD>&nbsp;</TD><TD>8</TD><TD>2021</TD></TR><TR><TD>zondag 8 augustus 2021</TD><TD>&nbsp;</TD><TD>8</TD><TD>2021</TD></TR><TR><TD>zondag 15 augustus 2021</TD><TD>&nbsp;</TD><TD>8</TD><TD>2021</TD></TR><TR><TD>zondag 22 augustus 2021</TD><TD>&nbsp;</TD><TD>8</TD><TD>2021</TD></TR><TR><TD>zondag 29 augustus 2021</TD><TD>&nbsp;</TD><TD>8</TD><TD>2021</TD></TR><TR><TD>zondag 5 september 2021</TD><TD>&nbsp;</TD><TD>9</TD><TD>2021</TD></TR><TR><TD>zondag 12 september 2021</TD><TD>&nbsp;</TD><TD>9</TD><TD>2021</TD></TR><TR><TD>zondag 19 september 2021</TD><TD>&nbsp;</TD><TD>9</TD><TD>2021</TD></TR><TR><TD>zondag 26 september 2021</TD><TD>&nbsp;</TD><TD>9</TD><TD>2021</TD></TR><TR><TD>zondag 3 oktober 2021</TD><TD>&nbsp;</TD><TD>10</TD><TD>2021</TD></TR><TR><TD>zondag 10 oktober 2021</TD><TD>&nbsp;</TD><TD>10</TD><TD>2021</TD></TR><TR><TD>zondag 17 oktober 2021</TD><TD>&nbsp;</TD><TD>10</TD><TD>2021</TD></TR><TR><TD>zondag 24 oktober 2021</TD><TD>&nbsp;</TD><TD>10</TD><TD>2021</TD></TR><TR><TD>zondag 31 oktober 2021</TD><TD>&nbsp;</TD><TD>10</TD><TD>2021</TD></TR><TR><TD>zondag 7 november 2021</TD><TD>&nbsp;</TD><TD>11</TD><TD>2021</TD></TR><TR><TD>zondag 14 november 2021</TD><TD>&nbsp;</TD><TD>11</TD><TD>2021</TD></TR><TR><TD>zondag 21 november 2021</TD><TD>&nbsp;</TD><TD>11</TD><TD>2021</TD></TR><TR><TD>zondag 28 november 2021</TD><TD>&nbsp;</TD><TD>11</TD><TD>2021</TD></TR><TR><TD>zondag 5 december 2021</TD><TD>&nbsp;</TD><TD>12</TD><TD>2021</TD></TR><TR><TD>zondag 12 december 2021</TD><TD>&nbsp;</TD><TD>12</TD><TD>2021</TD></TR><TR><TD>zondag 19 december 2021</TD><TD>&nbsp;</TD><TD>12</TD><TD>2021</TD></TR><TR><TD>zondag 26 december 2021</TD><TD>&nbsp;</TD><TD>12</TD><TD>2021</TD></TR><TR><TD>zondag 2 januari 2022</TD><TD>&nbsp;</TD><TD>1</TD><TD>2022</TD></TR><TR><TD>zondag 9 januari 2022</TD><TD>&nbsp;</TD><TD>1</TD><TD>2022</TD></TR><TR><TD>zondag 16 januari 2022</TD><TD>&nbsp;</TD><TD>1</TD><TD>2022</TD></TR><TR><TD>zondag 23 januari 2022</TD><TD>&nbsp;</TD><TD>1</TD><TD>2022</TD></TR><TR><TD>zondag 30 januari 2022</TD><TD>&nbsp;</TD><TD>1</TD><TD>2022</TD></TR><TR><TD>zondag 6 februari 2022</TD><TD>&nbsp;</TD><TD>2</TD><TD>2022</TD></TR><TR><TD>zondag 13 februari 2022</TD><TD>&nbsp;</TD><TD>2</TD><TD>2022</TD></TR><TR><TD>zondag 20 februari 2022</TD><TD>&nbsp;</TD><TD>2</TD><TD>2022</TD></TR><TR><TD>zondag 27 februari 2022</TD><TD>&nbsp;</TD><TD>2</TD><TD>2022</TD></TR><TR><TD>zondag 6 maart 2022</TD><TD>&nbsp;</TD><TD>3</TD><TD>2022</TD></TR><TR><TD>zondag 13 maart 2022</TD><TD>&nbsp;</TD><TD>3</TD><TD>2022</TD></TR><TR><TD>zondag 20 maart 2022</TD><TD>&nbsp;</TD><TD>3</TD><TD>2022</TD></TR><TR><TD>zondag 27 maart 2022</TD><TD>&nbsp;</TD><TD>3</TD><TD>2022</TD></TR><TR><TD>zondag 3 april 2022</TD><TD>&nbsp;</TD><TD>4</TD><TD>2022</TD></TR><TR><TD>zondag 10 april 2022</TD><TD>&nbsp;</TD><TD>4</TD><TD>2022</TD></TR><TR><TD>zondag 17 april 2022</TD><TD>&nbsp;</TD><TD>4</TD><TD>2022</TD></TR><TR><TD>zondag 24 april 2022</TD><TD>&nbsp;</TD><TD>4</TD><TD>2022</TD></TR><TR><TD>zondag 1 mei 2022</TD><TD>&nbsp;</TD><TD>5</TD><TD>2022</TD></TR><TR><TD>zondag 8 mei 2022</TD><TD>&nbsp;</TD><TD>5</TD><TD>2022</TD></TR><TR><TD>zondag 15 mei 2022</TD><TD>&nbsp;</TD><TD>5</TD><TD>2022</TD></TR><TR><TD>zondag 22 mei 2022</TD><TD>&nbsp;</TD><TD>5</TD><TD>2022</TD></TR><TR><TD>zondag 29 mei 2022</TD><TD>&nbsp;</TD><TD>5</TD><TD>2022</TD></TR><TR><TD>zondag 5 juni 2022</TD><TD>&nbsp;</TD><TD>6</TD><TD>2022</TD></TR><TR><TD>zondag 12 juni 2022</TD><TD>&nbsp;</TD><TD>6</TD><TD>2022</TD></TR><TR><TD>zondag 19 juni 2022</TD><TD>&nbsp;</TD><TD>6</TD><TD>2022</TD></TR><TR><TD>zondag 26 juni 2022</TD><TD>&nbsp;</TD><TD>6</TD><TD>2022</TD></TR><TR><TD>zondag 3 juli 2022</TD><TD>&nbsp;</TD><TD>7</TD><TD>2022</TD></TR><TR><TD>zondag 10 juli 2022</TD><TD>&nbsp;</TD><TD>7</TD><TD>2022</TD></TR><TR><TD>zondag 17 juli 2022</TD><TD>&nbsp;</TD><TD>7</TD><TD>2022</TD></TR><TR><TD>zondag 24 juli 2022</TD><TD>&nbsp;</TD><TD>7</TD><TD>2022</TD></TR><TR><TD>zondag 31 juli 2022</TD><TD>&nbsp;</TD><TD>7</TD><TD>2022</TD></TR><TR><TD>zondag 7 augustus 2022</TD><TD>&nbsp;</TD><TD>8</TD><TD>2022</TD></TR><TR><TD>zondag 14 augustus 2022</TD><TD>&nbsp;</TD><TD>8</TD><TD>2022</TD></TR><TR><TD>zondag 21 augustus 2022</TD><TD>&nbsp;</TD><TD>8</TD><TD>2022</TD></TR><TR><TD>zondag 28 augustus 2022</TD><TD>&nbsp;</TD><TD>8</TD><TD>2022</TD></TR><TR><TD>zondag 4 september 2022</TD><TD>&nbsp;</TD><TD>9</TD><TD>2022</TD></TR><TR><TD>zondag 11 september 2022</TD><TD>&nbsp;</TD><TD>9</TD><TD>2022</TD></TR><TR><TD>zondag 18 september 2022</TD><TD>&nbsp;</TD><TD>9</TD><TD>2022</TD></TR><TR><TD>zondag 25 september 2022</TD><TD>&nbsp;</TD><TD>9</TD><TD>2022</TD></TR><TR><TD>zondag 2 oktober 2022</TD><TD>&nbsp;</TD><TD>10</TD><TD>2022</TD></TR><TR><TD>zondag 9 oktober 2022</TD><TD>&nbsp;</TD><TD>10</TD><TD>2022</TD></TR><TR><TD>zondag 16 oktober 2022</TD><TD>&nbsp;</TD><TD>10</TD><TD>2022</TD></TR><TR><TD>zondag 23 oktober 2022</TD><TD>&nbsp;</TD><TD>10</TD><TD>2022</TD></TR><TR><TD>zondag 30 oktober 2022</TD><TD>&nbsp;</TD><TD>10</TD><TD>2022</TD></TR><TR><TD>zondag 6 november 2022</TD><TD>&nbsp;</TD><TD>11</TD><TD>2022</TD></TR><TR><TD>zondag 13 november 2022</TD><TD>&nbsp;</TD><TD>11</TD><TD>2022</TD></TR><TR><TD>zondag 20 november 2022</TD><TD>&nbsp;</TD><TD>11</TD><TD>2022</TD></TR><TR><TD>zondag 27 november 2022</TD><TD>&nbsp;</TD><TD>11</TD><TD>2022</TD></TR><TR><TD>zondag 4 december 2022</TD><TD>&nbsp;</TD><TD>12</TD><TD>2022</TD></TR><TR><TD>zondag 11 december 2022</TD><TD>&nbsp;</TD><TD>12</TD><TD>2022</TD></TR><TR><TD>zondag 18 december 2022</TD><TD>&nbsp;</TD><TD>12</TD><TD>2022</TD></TR><TR><TD>zondag 25 december 2022</TD><TD>&nbsp;</TD><TD>12</TD><TD>2022</TD></TR><TR><TD>zondag 1 januari 2023</TD><TD>&nbsp;</TD><TD>1</TD><TD>2023</TD></TR><TR><TD>zondag 8 januari 2023</TD><TD>&nbsp;</TD><TD>1</TD><TD>2023</TD></TR><TR><TD>zondag 15 januari 2023</TD><TD>&nbsp;</TD><TD>1</TD><TD>2023</TD></TR><TR><TD>zondag 22 januari 2023</TD><TD>&nbsp;</TD><TD>1</TD><TD>2023</TD></TR><TR><TD>zondag 29 januari 2023</TD><TD>&nbsp;</TD><TD>1</TD><TD>2023</TD></TR><TR><TD>zondag 5 februari 2023</TD><TD>&nbsp;</TD><TD>2</TD><TD>2023</TD></TR><TR><TD>zondag 12 februari 2023</TD><TD>&nbsp;</TD><TD>2</TD><TD>2023</TD></TR><TR><TD>zondag 19 februari 2023</TD><TD>&nbsp;</TD><TD>2</TD><TD>2023</TD></TR><TR><TD>zondag 26 februari 2023</TD><TD>&nbsp;</TD><TD>2</TD><TD>2023</TD></TR><TR><TD>zondag 5 maart 2023</TD><TD>&nbsp;</TD><TD>3</TD><TD>2023</TD></TR><TR><TD>zondag 12 maart 2023</TD><TD>&nbsp;</TD><TD>3</TD><TD>2023</TD></TR><TR><TD>zondag 19 maart 2023</TD><TD>&nbsp;</TD><TD>3</TD><TD>2023</TD></TR><TR><TD>zondag 26 maart 2023</TD><TD>&nbsp;</TD><TD>3</TD><TD>2023</TD></TR><TR><TD>zondag 2 april 2023</TD><TD>&nbsp;</TD><TD>4</TD><TD>2023</TD></TR><TR><TD>zondag 9 april 2023</TD><TD>&nbsp;</TD><TD>4</TD><TD>2023</TD></TR><TR><TD>zondag 16 april 2023</TD><TD>&nbsp;</TD><TD>4</TD><TD>2023</TD></TR><TR><TD>zondag 23 april 2023</TD><TD>&nbsp;</TD><TD>4</TD><TD>2023</TD></TR><TR><TD>zondag 30 april 2023</TD><TD>&nbsp;</TD><TD>4</TD><TD>2023</TD></TR><TR><TD>zondag 7 mei 2023</TD><TD>&nbsp;</TD><TD>5</TD><TD>2023</TD></TR><TR><TD>zondag 14 mei 2023</TD><TD>&nbsp;</TD><TD>5</TD><TD>2023</TD></TR><TR><TD>zondag 21 mei 2023</TD><TD>&nbsp;</TD><TD>5</TD><TD>2023</TD></TR><TR><TD>zondag 28 mei 2023</TD><TD>&nbsp;</TD><TD>5</TD><TD>2023</TD></TR><TR><TD>zondag 4 juni 2023</TD><TD>&nbsp;</TD><TD>6</TD><TD>2023</TD></TR><TR><TD>zondag 11 juni 2023</TD><TD>&nbsp;</TD><TD>6</TD><TD>2023</TD></TR><TR><TD>zondag 18 juni 2023</TD><TD>&nbsp;</TD><TD>6</TD><TD>2023</TD></TR><TR><TD>zondag 25 juni 2023</TD><TD>&nbsp;</TD><TD>6</TD><TD>2023</TD></TR><TR><TD>zondag 2 juli 2023</TD><TD>&nbsp;</TD><TD>7</TD><TD>2023</TD></TR><TR><TD>zondag 9 juli 2023</TD><TD>&nbsp;</TD><TD>7</TD><TD>2023</TD></TR><TR><TD>zondag 16 juli 2023</TD><TD>&nbsp;</TD><TD>7</TD><TD>2023</TD></TR><TR><TD>zondag 23 juli 2023</TD><TD>&nbsp;</TD><TD>7</TD><TD>2023</TD></TR><TR><TD>zondag 30 juli 2023</TD><TD>&nbsp;</TD><TD>7</TD><TD>2023</TD></TR><TR><TD>zondag 6 augustus 2023</TD><TD>&nbsp;</TD><TD>8</TD><TD>2023</TD></TR><TR><TD>zondag 13 augustus 2023</TD><TD>&nbsp;</TD><TD>8</TD><TD>2023</TD></TR><TR><TD>zondag 20 augustus 2023</TD><TD>&nbsp;</TD><TD>8</TD><TD>2023</TD></TR><TR><TD>zondag 27 augustus 2023</TD><TD>&nbsp;</TD><TD>8</TD><TD>2023</TD></TR><TR><TD>zondag 3 september 2023</TD><TD>&nbsp;</TD><TD>9</TD><TD>2023</TD></TR><TR><TD>zondag 10 september 2023</TD><TD>&nbsp;</TD><TD>9</TD><TD>2023</TD></TR><TR><TD>zondag 17 september 2023</TD><TD>&nbsp;</TD><TD>9</TD><TD>2023</TD></TR><TR><TD>zondag 24 september 2023</TD><TD>&nbsp;</TD><TD>9</TD><TD>2023</TD></TR><TR><TD>zondag 1 oktober 2023</TD><TD>&nbsp;</TD><TD>10</TD><TD>2023</TD></TR><TR><TD>zondag 8 oktober 2023</TD><TD>&nbsp;</TD><TD>10</TD><TD>2023</TD></TR><TR><TD>zondag 15 oktober 2023</TD><TD>&nbsp;</TD><TD>10</TD><TD>2023</TD></TR><TR><TD>zondag 22 oktober 2023</TD><TD>&nbsp;</TD><TD>10</TD><TD>2023</TD></TR><TR><TD>zondag 29 oktober 2023</TD><TD>&nbsp;</TD><TD>10</TD><TD>2023</TD></TR><TR><TD>zondag 5 november 2023</TD><TD>&nbsp;</TD><TD>11</TD><TD>2023</TD></TR><TR><TD>zondag 12 november 2023</TD><TD>&nbsp;</TD><TD>11</TD><TD>2023</TD></TR><TR><TD>zondag 19 november 2023</TD><TD>&nbsp;</TD><TD>11</TD><TD>2023</TD></TR><TR><TD>zondag 26 november 2023</TD><TD>&nbsp;</TD><TD>11</TD><TD>2023</TD></TR><TR><TD>zondag 3 december 2023</TD><TD>&nbsp;</TD><TD>12</TD><TD>2023</TD></TR><TR><TD>zondag 5 januari 2020</TD><TD>2</TD><TD>1</TD><TD>2020</TD></TR><TR><TD>zondag 12 januari 2020</TD><TD>2</TD><TD>1</TD><TD>2020</TD></TR><TR><TD>zondag 19 januari 2020</TD><TD>2</TD><TD>1</TD><TD>2020</TD></TR><TR><TD>zondag 26 januari 2020</TD><TD>2</TD><TD>1</TD><TD>2020</TD></TR><TR><TD>zondag 2 februari 2020</TD><TD>2</TD><TD>2</TD><TD>2020</TD></TR><TR><TD>zondag 9 februari 2020</TD><TD>2</TD><TD>2</TD><TD>2020</TD></TR><TR><TD>zondag 16 februari 2020</TD><TD>2</TD><TD>2</TD><TD>2020</TD></TR><TR><TD>zondag 23 februari 2020</TD><TD>2</TD><TD>2</TD><TD>2020</TD></TR><TR><TD>zondag 1 maart 2020</TD><TD>2</TD><TD>3</TD><TD>2020</TD></TR><TR><TD>zondag 8 maart 2020</TD><TD>2</TD><TD>3</TD><TD>2020</TD></TR><TR><TD>zondag 15 maart 2020</TD><TD>2</TD><TD>3</TD><TD>2020</TD></TR><TR><TD>zondag 22 maart 2020</TD><TD>2</TD><TD>3</TD><TD>2020</TD></TR><TR><TD>zondag 29 maart 2020</TD><TD>2</TD><TD>3</TD><TD>2020</TD></TR><TR><TD>zondag 5 april 2020</TD><TD>4</TD><TD>4</TD><TD>2020</TD></TR><TR><TD>zondag 12 april 2020</TD><TD>4</TD><TD>4</TD><TD>2020</TD></TR><TR><TD>zondag 19 april 2020</TD><TD>4</TD><TD>4</TD><TD>2020</TD></TR><TR><TD>zondag 26 april 2020</TD><TD>4</TD><TD>4</TD><TD>2020</TD></TR><TR><TD>zondag 3 mei 2020</TD><TD>4</TD><TD>5</TD><TD>2020</TD></TR><TR><TD>zondag 10 mei 2020</TD><TD>2</TD><TD>5</TD><TD>2020</TD></TR><TR><TD>zondag 17 mei 2020</TD><TD>2</TD><TD>5</TD><TD>2020</TD></TR><TR><TD>zondag 24 mei 2020</TD><TD>2</TD><TD>5</TD><TD>2020</TD></TR><TR><TD>zondag 31 mei 2020</TD><TD>2</TD><TD>5</TD><TD>2020</TD></TR><TR><TD>zondag 7 juni 2020</TD><TD>2</TD><TD>6</TD><TD>2020</TD></TR><TR><TD>zondag 14 juni 2020</TD><TD>2</TD><TD>6</TD><TD>2020</TD></TR><TR><TD>zondag 21 juni 2020</TD><TD>8</TD><TD>6</TD><TD>2020</TD></TR><TR><TD>zondag 28 juni 2020</TD><TD>2</TD><TD>6</TD><TD>2020</TD></TR><TR><TD>zondag 5 juli 2020</TD><TD>2</TD><TD>7</TD><TD>2020</TD></TR><TR><TD>zondag 12 juli 2020</TD><TD>2</TD><TD>7</TD><TD>2020</TD></TR><TR><TD>zondag 19 juli 2020</TD><TD>2</TD><TD>7</TD><TD>2020</TD></TR><TR><TD>zondag 26 juli 2020</TD><TD>2</TD><TD>7</TD><TD>2020</TD></TR><TR><TD>zondag 2 augustus 2020</TD><TD>2</TD><TD>8</TD><TD>2020</TD></TR><TR><TD>zondag 9 augustus 2020</TD><TD>2</TD><TD>8</TD><TD>2020</TD></TR><TR><TD>zondag 16 augustus 2020</TD><TD>2</TD><TD>8</TD><TD>2020</TD></TR><TR><TD>zondag 23 augustus 2020</TD><TD>2</TD><TD>8</TD><TD>2020</TD></TR><TR><TD>zondag 30 augustus 2020</TD><TD>2</TD><TD>8</TD><TD>2020</TD></TR><TR><TD>zondag 6 september 2020</TD><TD>2</TD><TD>9</TD><TD>2020</TD></TR><TR><TD>zondag 13 september 2020</TD><TD>2</TD><TD>9</TD><TD>2020</TD></TR><TR><TD>zondag 20 september 2020</TD><TD>2</TD><TD>9</TD><TD>2020</TD></TR><TR><TD>zondag 27 september 2020</TD><TD>2</TD><TD>9</TD><TD>2020</TD></TR><TR><TD>zondag 4 oktober 2020</TD><TD>2</TD><TD>10</TD><TD>2020</TD></TR><TR><TD>zondag 11 oktober 2020</TD><TD>2</TD><TD>10</TD><TD>2020</TD></TR><TR><TD>zondag 18 oktober 2020</TD><TD>2</TD><TD>10</TD><TD>2020</TD></TR><TR><TD>zondag 25 oktober 2020</TD><TD>2</TD><TD>10</TD><TD>2020</TD></TR><TR><TD>zondag 1 november 2020</TD><TD>2</TD><TD>11</TD><TD>2020</TD></TR><TR><TD>zondag 8 november 2020</TD><TD>2</TD><TD>11</TD><TD>2020</TD></TR><TR><TD>zondag 15 november 2020</TD><TD>2</TD><TD>11</TD><TD>2020</TD></TR><TR><TD>zondag 22 november 2020</TD><TD>2</TD><TD>11</TD><TD>2020</TD></TR><TR><TD>zondag 29 november 2020</TD><TD>2</TD><TD>11</TD><TD>2020</TD></TR><TR><TD>zondag 6 december 2020</TD><TD>2</TD><TD>12</TD><TD>2020</TD></TR><TR><TD>zondag 13 december 2020</TD><TD>2</TD><TD>12</TD><TD>2020</TD></TR><TR><TD>zondag 20 december 2020</TD><TD>2</TD><TD>12</TD><TD>2020</TD></TR><TR><TD>zondag 27 december 2020</TD><TD>2</TD><TD>12</TD><TD>2020</TD></TR><TR><TD>zondag 3 januari 2021</TD><TD>2</TD><TD>1</TD><TD>2021</TD></TR><TR><TD>zondag 10 januari 2021</TD><TD>2</TD><TD>1</TD><TD>2021</TD></TR><TR><TD>zondag 17 januari 2021</TD><TD>2</TD><TD>1</TD><TD>2021</TD></TR><TR><TD>zondag 24 januari 2021</TD><TD>2</TD><TD>1</TD><TD>2021</TD></TR><TR><TD>zondag 31 januari 2021</TD><TD>2</TD><TD>1</TD><TD>2021</TD></TR><TR><TD>zondag 7 februari 2021</TD><TD>2</TD><TD>2</TD><TD>2021</TD></TR><TR><TD>zondag 14 februari 2021</TD><TD>2</TD><TD>2</TD><TD>2021</TD></TR><TR><TD>zondag 21 februari 2021</TD><TD>2</TD><TD>2</TD><TD>2021</TD></TR><TR><TD>zondag 28 februari 2021</TD><TD>2</TD><TD>2</TD><TD>2021</TD></TR><TR><TD>zondag 7 maart 2021</TD><TD>2</TD><TD>3</TD><TD><P>2021</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want that he looks 12 months back so the avarige of the last 12 months</P><P>&nbsp;</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><img /></P></DIV></DIV> Thu, 01 Oct 2020 07:41:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-the-average-number-of-sick-reports/m-p/1406693#M25965 bastiaan2222 2020-10-01T07:41:44Z Re: display the average number of sick reports https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-the-average-number-of-sick-reports/m-p/1406795#M25968 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="262181" data-lia-user-login="bastiaan2222" class="lia-mention lia-mention-user">bastiaan2222</a> , not very clear. In case you want to compare year vs year. You can use time intelligence and date table</P> <P>&nbsp;</P> <P>examples</P> <P>YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))<BR />Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))<BR />This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))<BR />Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))<BR />Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))<BR />Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))<BR />//Only year vs Year, not a level below</P> <P>&nbsp;</P> <P><BR />This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))<BR />Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))</P> <P>&nbsp;</P> <P>Power BI — Year on Year with or Without Time Intelligence <BR /><A href="https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a" target="_blank">https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a</A></P> <P>&nbsp;</P> <P>To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer : <BR /><A href="https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions" target="_blank">https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions</A> <BR /><BR /><BR /><BR />Appreciate your Kudos.</P> Thu, 01 Oct 2020 08:21:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-the-average-number-of-sick-reports/m-p/1406795#M25968 amitchandak 2020-10-01T08:21:37Z Re: display the average number of sick reports https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-the-average-number-of-sick-reports/m-p/1412952#M26204 Please do not fall into the trap that so many people do. For your own safety and sanity create a proper date table in the model and never, ever, ever rely on the built-in automatic auto-generated time hierarchies. What's more, the time-intel functions work correctly only on proper date tables. Since you don't have one, please forget about getting correct results. Mon, 05 Oct 2020 11:01:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-the-average-number-of-sick-reports/m-p/1412952#M26204 Anonymous 2020-10-05T11:01:27Z Re: display the average number of sick reports https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-the-average-number-of-sick-reports/m-p/1412987#M26206 <P>Je mag je vraag ook in het nederlands posten, dan wordt het misschien duidelijk voor me en kan ik je helpen aangezien ik ook nederlands ben. gr., Steve.&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="262181" data-lia-user-login="bastiaan2222" class="lia-mention lia-mention-user">bastiaan2222</a>&nbsp;</P> Mon, 05 Oct 2020 11:11:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-the-average-number-of-sick-reports/m-p/1412987#M26206 stevedep 2020-10-05T11:11:13Z