calculated table with fill down

Question

Hello Everyone!Excuseme my english i'm Colombian jeje,&nbsp;i need help for create&nbsp; a calculated table&nbsp;i have a table as below:| 1 | Comercial A | Customer X | Regional 1 | 01/01/2023 | 250.000 |&nbsp;| 2 | Comercial A | Customer Y | Regional 2 | 01/02/2023 | 360.000 || 3 | Comercial A | Customer Z | Regional 1 | 01/03/2023 |&nbsp;480.000 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.| 12 | Comercial A | Customer F | Regional 3 | 01/12/2023 | 650.000 || 13 | Comercial B | Customer G | Regional 2 | 01/01/2023 | 220.000 || 14 | Comercial B | Customer G | Regional 1 | 01/02/2023 | 150.000 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .... etc. i have a one date per month per categories.------------------------------------------------------------------------------------------------------------------------------------------------i need a table as below:| 1 | Comercial A | Customer X | Regional 1 | 01/01/2023 | 250.000/31 |&nbsp;| 2 | Comercial A | Customer X | Regional 1 | 02/01/2023 | 250.000/31 |&nbsp;| 3 | Comercial A | Customer X | Regional 1 | 03/01/2023 | 250.000/31 |&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.| 31 | Comercial A | Customer X | Regional 1 | 31/01/2023 | 250.000/31 |&nbsp;| 32 | Comercial A | Customer Y | Regional 2 | 01/02/2023 | 360.000/28 || 33 | Comercial A | Customer Y | Regional 2 | 02/02/2023 | 360.000/28 || 34 | Comercial A | Customer Y | Regional 2 | 03/02/2023 | 360.000/28 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.| n | Comercial A | Customer Y | Regional 2 | 28/02/2023 | 360.000/28 || n | Comercial A | Customer Z | Regional 1 | 01/03/2023 |&nbsp;480.000/31|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.| n | Comercial A | Customer Z | Regional 1 | 31/03/2023 |&nbsp;480.000/31|| 13 | Comercial B | Customer G | Regional 2 | 01/01/2023 | 220.000 /31|......etc&nbsp;thank you very much in case you can help me&nbsp;😊&nbsp; &nbsp; &nbsp;

vicky_ · Answer

you can use something likeNew Column = DIVIDE([Your Column],&nbsp;DAY(EOMONTH('Table'[Date], 0)))

Forum Discussion

calculated table with fill down

1 Reply

Related content

Direct Lake Model - Calculated Column/Tables

How to search specific word in table filter Calculations

Directlake semantic model, calculated table

PowerBI - Matrix table, hide values used only for a visual calculation

Calculated table update