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

     

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.