cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## IF AND dax Formula

Hey,

So I'm trying to add a column to filter the current month of the year. So far I've only been able to filter out the current month.

deletePresentMonth = if(value(Date[Month]) = MONTH(today());true;false)

What/How should I add another rule for the current year?

Thanks!

1 ACCEPTED SOLUTION
Impactful Individual

Simply do an AND or &&, I usually use &&

State of Month = IF(YEAR(community[Date])=year(NOW()) && MONTH(community[Date]) = MONTH(NOW()),"Current Month","Previous Month")

hope this helps

4 REPLIES 4
New Member

Hi.

So I have ;

tbl One - Column This (either 1 or 2) - Column That (either A or B)

I want a new column Then where This = 2 AND That = B marked "YES"

THEN = IF('tbl One'[THIS] = "2")&& IF('tbl One'[That] = "B", "YES")

And it doesn't work...

Too few arguments were passed to the AND function. The minimum argument count for the function is 2.

Any DAX Jedi in the house ?

I know this is a bit late...

But the arguments error came up because you did not present an alternate to the "YES" true if statement.

Here is what I would change...

THEN = IF('tbl One'[THIS] = "2")&& IF('tbl One'[That] = "B", "YES", "NO")

Impactful Individual

Simply do an AND or &&, I usually use &&

State of Month = IF(YEAR(community[Date])=year(NOW()) && MONTH(community[Date]) = MONTH(NOW()),"Current Month","Previous Month")

hope this helps

Frequent Visitor

Perfect @ovetteabejuela,

Thank you a lot

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors