Forum Discussion

MarvinGallo's avatar
MarvinGallo
Frequent Visitor
7 years ago
Solved

Identify Blank Cells in RELATED column

Hi Everyone,    I created a RELATED column on the DATA section of my report to return a value matching my column. As it was expected, the column contains Blank values as well as zero values as Deci...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi MarvinGallo ,

    We can use the ISBLANK() function to judge if it is a blank value, please refer to the following DAX query:

    KPIValueFY18 =
IF (
    ISBLANK ( Table1[Value2] ),
    "N/A",
    IF (
        Table1[Value1] = Table1[Value2],
        "Same",
        IF ( Table1[Value1] < Table1[Value2], "Higher", "Lower" )
    )
)

    The result will like below:

    Best Regards,

    Teige

TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi MarvinGallo ,

We can use the ISBLANK() function to judge if it is a blank value, please refer to the following DAX query:

KPIValueFY18 =
IF (
    ISBLANK ( Table1[Value2] ),
    "N/A",
    IF (
        Table1[Value1] = Table1[Value2],
        "Same",
        IF ( Table1[Value1] < Table1[Value2], "Higher", "Lower" )
    )
)

The result will like below:

Best Regards,

Teige