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 ...
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

     

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.