how to use the or statement

[gheecalipes25]

Hi,

i have to format a date but then will need to use the or statement. which means if Time Reported = null, it will show and format Updated Dated.

Here's my current formula, but is not actually getting the result i need.

If Status = Closed, format date(if time reported), if time reported = null, format the Updated Date instead. 

Thanks to those who will provide feedback.

[gheecalipes25]

Hi, 

The current formula i am using is:

var_Week Number Closed = FORMAT(WEEKNUM('SMC OUTAGE_FACT'[TIMERESOLVED] || SMC OUTAGE_FACT'[UPDATED] ,2),"00")

but i am not getting the result i need. 😞

[Arul]

@gheecalipes25 ,

Can you share some sample data and expected output bit more in detail?

[mlsx4 · Accepted solution]

Hi @gheecalipes25 

I don't really understand your formula, but if you need an or you can use the formula OR(Condition1, Condition2) or simply write || between the conditions: condition1 || condition2

If this message isn't enough, please try to explain it deeper