cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## calculated table with fill down

Hello Everyone!

Excuseme my english i'm Colombian jeje,

i need help for create  a calculated table

i have a table as below:

| 1 | Comercial A | Customer X | Regional 1 | 01/01/2023 | 250.000 |

| 2 | Comercial A | Customer Y | Regional 2 | 01/02/2023 | 360.000 |

| 3 | Comercial A | Customer Z | Regional 1 | 01/03/2023 | 480.000 |

.

.

.

| 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 |
.... 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 |

| 2 | Comercial A | Customer X | Regional 1 | 02/01/2023 | 250.000/31 |

| 3 | Comercial A | Customer X | Regional 1 | 03/01/2023 | 250.000/31 |

.

.

.

| 31 | Comercial A | Customer X | Regional 1 | 31/01/2023 | 250.000/31 |

| 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 |

.

.

.

| n | Comercial A | Customer Y | Regional 2 | 28/02/2023 | 360.000/28 |

| n | Comercial A | Customer Z | Regional 1 | 01/03/2023 | 480.000/31|

.

.

.

| n | Comercial A | Customer Z | Regional 1 | 31/03/2023 | 480.000/31|
| 13 | Comercial B | Customer G | Regional 2 | 01/01/2023 | 220.000 /31|
......etc

thank you very much in case you can help me 😊

Super User

you can use something like
DAY(EOMONTH('Table'[Date], 0)))

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.