How to calculate the sum of a specific value

[Syndicate_Admin]

Good morning, I have a question, as can I do to determine the next calculation.

the idea is that, everything that has FEC- is 1 and everything for everything else is 0.

Thank you

[serpiva64 · Accepted solution]

Hi,

you can try to create a calculate column:

Column = if(Left( 'FAC_QUEST'[Nro documento],4)="FEC-",1,0)

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !