Create calculated column from a different table

Question

I have a date dimension table and a table that contains the latest date available (only 1 row). There is no relationship between these 2 tables. I'm trying to create a calculated column in Date dimension using this (getting the monthend date of latest previous month and flagging Y or N):

_Flag := IF('Datex'[Date] <=  EOMONTH('Latest Datex'[Latest Date], -1), "Y", "N")

I'm having an error using above. How do I write it?

j.p · Accepted Answer · 2021-11-19 15:42:23Z

0

Use New Measure:

_Flag = IF(MAX('Datex'[Date]) <= EOMONTH(MAX('Latest Datex'[Latest Date]), -1), "Y", "N")

answered Nov 19, 2021 at 15:42

j.p

1066 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create calculated column from a different table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related