Forum Discussion

Helper I

4 years ago

Solved

How can I create a calculated table including values column and if statement?

Hi experts, I have a table like; Crr Dep Arr Date aa xxx yyy 1.08.2021 aa yyy xxx 2.08.2021 bb ttt aaa 3.08.2021 bb ttt jjj 4.08.2021 bb www ttt 5.08.2021 ...

Need Help

SteveHailey

4 years ago

Hello akay23.

You could use:

New table with SUMMARIZECOLUMNS = 
SUMMARIZECOLUMNS(
    'Data'[Dep],
    "Ops",
        IF(
            COUNTROWS( CALCULATETABLE( 'Data', 'Data'[Crr] = "aa" ) )
                > 0,
            "IN",
            "Out"
        )
)

Or you could use:

New table with ADDCOLUMNS and SUMMARIZE = 
ADDCOLUMNS(
    SUMMARIZE( 'Data', 'Data'[Dep] ),
    "Ops",
        IF(
            COUNTROWS( CALCULATETABLE( 'Data', 'Data'[Crr] = "aa" ) )
                > 0,
            "IN",
            "Out"
        )
)

I attached a .pbix file here in case it's helpful.

-Steve

SteveHailey

Solution Specialist

4 years ago

Hello akay23.

You could use:

New table with SUMMARIZECOLUMNS = 
SUMMARIZECOLUMNS(
    'Data'[Dep],
    "Ops",
        IF(
            COUNTROWS( CALCULATETABLE( 'Data', 'Data'[Crr] = "aa" ) )
                > 0,
            "IN",
            "Out"
        )
)

Or you could use:

New table with ADDCOLUMNS and SUMMARIZE = 
ADDCOLUMNS(
    SUMMARIZE( 'Data', 'Data'[Dep] ),
    "Ops",
        IF(
            COUNTROWS( CALCULATETABLE( 'Data', 'Data'[Crr] = "aa" ) )
                > 0,
            "IN",
            "Out"
        )
)

I attached a .pbix file here in case it's helpful.

-Steve