True/False measure for "Is this ISO year" & "Is this ISO week"

[Anonymous]

Hi all,

I need some help with a dax formula which combines two true/false measures.

Variables:

Is This ISO_Year = IF(VALUE(Calender[ISO_Year]) = VALUE(YEAR(TODAY())), True, False)

True if the selected date value is in the current ISO year. Else False.

Is before This Week = IF(VALUE(Calender[ISO_WeekNumber]) < VALUE(Calender[Current ISO_Weeknumber]), True, False)

True if the selected date value is before this week. Else False.

Results for those combined below (current date 23-7-2020 = week 30; translation: waar=true, onwaar=false)

Now I'm struggling combining these two variables. I would like to create the value "Is this week & ISO year".

In other words: 

IF:

Current ISO year = true

Before this week = false

THEN:

True

ELSE:

False

I've tried nesting the above formulas, but I haven't succeeded yet. Can anyone help me out?

[Greg_Deckler · Accepted solution]

@Anonymous - Should be:

Column = IF([Current ISO Year] && NOT([Before this week]),TRUE(),FALSE())

[Anonymous]

Thanks for the very quick responses! Both solutions work great!

I was making it way to complicated with nesting both individual If-fomulas. I'm kind of wondering though what I should have done to make it work with a nested if construction. I felt like I was close, but in the end I kept getting errors.

[Pragati11]

HI @Anonymous ,

Sometimes that happens when we overcomplicate DAX after working for a long time on it.

But there is always an easier way of writing them 🙂

Thanks,

Pragati

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Try creating a calculated column as follows:

IF ([Is This ISO_Year] = TRUE() && [Is before This Week] = FALSE(), TRUE(), FALSE())

Thanks,

Pragati

[Greg_Deckler · Accepted solution]

@Anonymous - Should be:

Column = IF([Current ISO Year] && NOT([Before this week]),TRUE(),FALSE())