Measure that shows dates thru yesterday

[Del235]

Today is 9/20/2023.  I'd like to create a measure that would show All dates thru yesterday.  I.E. 1/1, 1/2 ... 9/18, 9/19.  It would always reference what today is and show all dates thru yesterday.

Thanks.

[Del235]

My apologies... Table with all dates in this year up to yesterday.

[some_bih]

Hi @Del235 your cal. table could be

Test =

VAR __curent_year = YEAR(TODAY())

VAR __yesterday = TODAY()

RETURN

    FILTER(

        'Date',

        YEAR('Date'[Date]) = __curent_year &&

        'Date'[Date]< __yesterday

    )

Did I answer your question? Kudos appreciated / accept solution!

[Del235]

I will check

[Del235]

I get the following error:

Feedback Type:
Frown (Error)

Error Message:
'approx_count_distinct' supports only field access.

[some_bih]

Hi @Del235 there is no measure in my proposed solution so please check your error.

[Del235]

Error appears but the table is created as Test.  The table shows every date in 2023 but it doesn't stop at 9/20, which would have been yesterday.  Which field should I be using?

[some_bih]

Hi @Del235 try just to rename table which is not Test. If it not works, please share your Date table details.

[Del235]

I have a Date table.  The formula is now

Test = VAR __curent_year = YEAR ( TODAY ()) VAR __yesterday = TODAY () RETURN     FILTER (         'DateTable',         YEAR ('DateTable'[Date]) = __curent_year &&         'DateTable'[Date]< __yesterday     )  

I get the follow error:

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

[some_bih]

Hi @Del235 I wrote you solution as new calculated table, not column. 

Do you need column in your Date table to mark somehow dates in current year less than yesterday?

[some_bih]

Hi @Del235 

Measure is usually something which is aggregrable, like sum, min...

When you wrote all the dates up to yesterday, you mean table with all dates in ths year up to yesterday? Or...