Forum Discussion

DMB90's avatar
DMB90
Helper II
8 months ago
Solved

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

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 QuartersAnnual QuartersTest PhaseStatus
Q1 2025 Year End/AnnualComplete
Q4 2025 Year End/AnnualComplete
 Q4 2025Year End/AnnualIncomplete
Q1 2025 Year End/AnnualComplete
Q2 2025 RemediationComplete
Q2 2025 Year End/AnnualComplete
 Q3 2025Year End/AnnualComplete
 Q3 2025Year End/AnnualComplete
 Q2 2025Year End/AnnualIncomplete
 Q4 2025Year End/AnnualComplete
 Q3 2025Year End/AnnualComplete
Need Help
Show and Tell
  • Anand24's avatar
    Anand24
    8 months ago

    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

     

5 Replies

  • Anand24's avatar
    Anand24
    Super User
    8 months ago

    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's avatar
      DMB90
      Helper II
      8 months ago

      Thanks everyone! 

       

      This one did the trick.

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    8 months ago

    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]
        )
    )
  • Royel's avatar
    Royel
    Super User
    8 months ago

    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.

     

  • cengizhanarslan's avatar
    cengizhanarslan
    Super User
    8 months ago

    Please try the formula below:

     

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