Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Karim Mohsni]

Hi ALL
Thanks for your help
I want to extract the 6 characters on the right of the column "Libellé" when the column "folio.journal Auxiliaire" = "Facturation" and put the result in a new column










I had the following error message








——————————
Karim Mohsni
Auditor
——————————
      

[Lotta Carlsson]

HI, 
Not sure why you want to use CALCUALTE in a calculated column, when all you want to do is to extract some values.

Perhaps I do not understand your requirements. 🙂

Wouldn’t just a simple IF function do?

Ex: DossierFacts = IF(‘Comptabilité'[folio.Journal Auxiliaire] = “Facturation”; RIGHT([Libellé];6))

——————————
/KR
Lotta Carlsson
BI Developer
——————————
——————————————-

[Karim Mohsni]

Hi Lotta
thanks for your Help

——————————
Karim Mohsni
Auditor
——————————
——————————————-