DAX FILTER function with multiple criteria
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