DAX FILTER function with multiple criteria

Shekar Nandi 21 Reputation points
2021-01-25T11:37:19.99+00:00

60179-add-column.png

Hi Expert.

I still new on this and not sure if my explain is good enough or not. Sorry for any inconvenient cause.

here is what I'm Looking for, I wan to add new column based on Three columns parameters.

INCLUDES FILTERS [Month Name] : less than Equal to April
EXCLUDES FILTERS [Date ]: less than or equal to March 2020
EXCLUDES FILTERS [Date] : less than or equal to April 2020
Else : APril

INCLUDES FILTERS [Month Name] : Equal to May
EXCLUDES FILTERS [Date ]: less than or equal to April 2020
EXCLUDES FILTERS [Date] : less than or equal to May 2020
Else : May

Likewise

I'm trying to calculation column in power bi from the above logic(Please see attached)

Many Thanks

Microsoft 365 and Office Development Other
Microsoft 365 and Office Excel For business Windows
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.