Forum Discussion

Helper IV

2 years ago

Solved

LOOKUP first date in remote table

I am trying to get a (fictitious) first date from my 'Calendar' table where I only have a [Fiscal Year Quarter] in my source data. My 'Calendar' table contains a complete running table of [Date], [F...

Need Help

ryan_mayu
2 years ago
LUCASM

is this what you want?

Column =

VAR _q=right('Table'[Fiscal Year Quarter],1)*1

VAR _m=_q*3+1

return DATE(2000+MID('Table'[Fiscal Year Quarter],3,2)*1,_m,1)