Conditional column

[afrutos]

Hi everyone, 
I have these two columns, one for Season and the other one for Chapter.
And I would like to create a Column that in case the season is not null/blank, then appear, S1, if not, continue in blank.
But I can manage to do that.

Thank you everyone

[v-eqin-msft · Accepted solution]

Hi @afrutos ,

You may use & to replace the "+" :

=if [NroTemporada]<> null then "T. " &Number.ToText(  [NroTemporada]) else [NroTemporada]

If you want to use DAX, please try:

Column = 
VAR _STR=CONVERT([NroTemporada],STRING)
RETURN IF( _STR<>"", "T. " &_STR, _STR)

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[afrutos]

Hi, @BA_Pete 
It works for the ones that have NroTemporada not null. But Ithought I could just not shown the null ones, as in the example for not to have it duplicated. 

[BA_Pete]

Hi @afrutos ,

Try this in a new custom column:

if [NroTemporada] <> null then "S1" else [NroTemporada]

Pete

[afrutos]

I would need something like this

"T. " + [NroTemporada]
So that I could have T. 1, T. 2.....

[BA_Pete]

I see.

Try this instead then:

if [NroTemporada] <> null
then Text.Combine({"T. ", Text.From([NroTemporada])}, "")
else [NroTemporada]

Pete