Error Message - Cannot Convert Value of Type Text to Type True/False (Using Quarters)

[DMB90]

Hi,

I have a table in Power BI and what I want the statement to say is:

If "Test Phase" is equal to Year End/Annual and "Status" is equal to "Complete, then pull in either the RF Quarters or Annual Quarters. However, I keep getting the error message "Cannot Convert Value of Type Text to Type True/False" when doing that. How do I resolve this?

RF Quarters	Annual Quarters	Test Phase	Status
Q1 2025		Year End/Annual	Complete
Q4 2025		Year End/Annual	Complete
	Q4 2025	Year End/Annual	Incomplete
Q1 2025		Year End/Annual	Complete
Q2 2025		Remediation	Complete
Q2 2025		Year End/Annual	Complete
	Q3 2025	Year End/Annual	Complete
	Q3 2025	Year End/Annual	Complete
	Q2 2025	Year End/Annual	Incomplete
	Q4 2025	Year End/Annual	Complete
	Q3 2025	Year End/Annual	Complete

[cengizhanarslan]

Please try the formula below:

Measure =
IF (
Table[Test Phase] = "Year End/Annual" && Table[Status] = "Complete",
COALESCE ( Table[RF Quarters], Table[Annual Quarters] ),
BLANK ()
)

[Royel]

Hi @DMB90 check out this easy dax to fix your issue 

Qtr & Year = 
IF(
    [Test Phase] = "Year End/Annual" && [Status] = "Complete",
    IF(
        NOT ISBLANK([RF Quarters]),
        [RF Quarters],
        [Annual Quarters]
    ),
    BLANK()
)

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

I’d love to stay connected. Join me on LinkedIn for more tips, learning paths, and real-world Fabric & Power BI solutions.

[Anand24 · Accepted solution]

Hi @DMB90,
Try this dax for a new calculated column:

Conditional_Column =
IF(
    Test_Table[Test Phase] = "Year End/Annual" && Test_Table[Status] = "Complete",
    IF(
        Test_Table[RF Quarters] <> BLANK(),
        Test_Table[RF Quarters],
        Test_Table[Annual Quarters]
    ),
    BLANK()
)

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[DMB90]

Thanks everyone! 

This one did the trick.

[Jihwan_Kim]

Hi, 

I am not sure if I understood your question correctly, but please check the below image and the attached pbix file.

calculated column 01 = 
IF(data[Test Phase] = "Year End/Annual" && data[Status] = "Complete", 
    IF(not ISBLANK(data[RF Quarters]), 
            data[RF Quarters], 
            data[Annual Quarters]
        )
    )