topic Re: Error with the year change in DAX Commands and Tips

Error with the year change

Anonymous — Tue, 04 Jan 2022 11:17:56 GMT

Hello,

I am getting the below error when refreshing a report with data that includes dates from 2022.

How would I modify the formula to include 2022 with the same principle, like =IF(OR in excel?

Many thanks!

Re: Error with the year change

PaulOlding — Tue, 04 Jan 2022 11:37:06 GMT

Hi Anonymous

You could make it

IF(YEAR >= 2021, ...

then it'll work for 2023 too.

DAX does have an OR function. If you want to use that then it would be

IF(OR(YEAR = 2021, YEAR = 2022), ...

Incidentally, is Week of Year a column name? The syntax error is coming from there. You should reference a column name like this

'Table Name'[Column Name]

Re: Error with the year change

Anonymous — Tue, 04 Jan 2022 14:12:01 GMT

Thanks a lot PaulOlding !

Re: Error with the year change

VahidDM — Tue, 04 Jan 2022 23:13:35 GMT

Hi Anonymous

As PaulOlding mentioned, you can use below for including 2022:

IF(YEAR >= 2021

IF(OR(YEAR = 2021, YEAR = 2022),

IFYEAR = 2021 || YEAR = 2022,

and the error is for that Week of Year, if that is the column name and you want to create measure, you need to use it in [ ] with an aggregation formula, like MAX(table[Week of Year]), otherwise, if that is a measure, you need to use it in [ ] lke this [Week of Year], but if you want to create a calculated column you can just use the table[Week of Year] in your formula.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/