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

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions