Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Extract date from text

Hello All,   I have a stand alone table in Live connection to tabular model. I am trying to create a report level measure as i dont have access to Tabular model.   I have a column FX_DATEKEY but ...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Anonymous ,

     

    Sorry for the miss direction but when handling with live connections on tabular models some expressions are not valid try the following:

     

    DateFx =
RIGHT ( LASTNONBLANK ( 'HFM FX Rate Actual'[FX_DATEKEY], 0 ), 8 )

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
7 years ago

Hi Anonymous ,

 

Sorry for the miss direction but when handling with live connections on tabular models some expressions are not valid try the following:

 

DateFx =
RIGHT ( LASTNONBLANK ( 'HFM FX Rate Actual'[FX_DATEKEY], 0 ), 8 )

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you so much it worked.