Create a Boolean Field/Measure based on the condition

[cruzp]

Hello,

I am in the process of migrating a calculated field from Tableau to Power BI.

I have a PBI model that contains dim - fact - dim (all are one to many relationship) which is good.

Then I need to have a table like the picture below in the report view with just the addition of the new field 'Project Ongoing':

Expected Output:

• PROJ-000101 is True because the date on the End Current is 17/10/2022 which is less than the Next First Month from today (01/08/2023)
• PROJ-000185 is False because the date on the End Current is 30/11/2023 which is greater than the Next First Month from today (01/08/2023)
• PROJ-002307 is True because Project Removed has '✔' 

My objective is to generate a new field or a measure called 'Project Ongoing' based on the expected output i have given above:

Tableau Project Ongoing calculated field to be migrated in Power BI DAX

[End Current] < [Next Month] OR [Project Removed]

Parameter:
Next Month (should be Dynamic) = Next month from today's month (01/08/2023) if based as of today.

[cruzp]

@Anonymous hi, can u able to help me on this?

[amitchandak]

@cruzp , Try like

Project Ongoing =
VAR CurrentDate = TODAY()
VAR NextMonth = EOMONTH(CurrentDate, 1)
RETURN IF([End Current] < NextMonth || [Project Removed] = "✔", TRUE(), FALSE())