Shorten a table (remove rows) as of condition (1st blank cell)

[Yazid]

Dear,

I have a table "TRUNCATED 2024" and I want to shorten the table as soon as the 1st empty cell begins

Thanks in advance for your support

[v-kaiyue-msft · Accepted solution]

Hi @Yazid ,

1. Based on your description, I created some data and wrote a calculated column.

Column =
VAR _current_year = YEAR(TODAY())
RETURN
SWITCH(TRUE(),
'Table'[date].[Year] = _current_year,'Table'[date],
BLANK())

2. Create the calculation table.

table2 = FILTER(
'Table',
NOT(ISBLANK('Table'[Column]))
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Yazid]

Thanks a lot !

[ExcelMonke]

You can filter out 0s. But the table will still contain these. Best way to do this is in the Transform data steps. Your DAX won't work here, and you will need to use Power Query M Language