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

     

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]
        )
    )