cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Anonymous
Not applicable

## SELECTCOLUMNS performs wrong calculation on some tables

Hi All,

I am getting crazy by a weird behaviour of SELECTCOLUMNS with some - but not all - tables in my dataset.
Since I need to split my data on a yearly basis, I use SC to create a new table with just required columns.
The problem is that same formula produces different outcomes:
- in some cases, values are entered in respective columns (2020 values in 2020 col, 2021 values in 2021 col, and so on)

- in other cases, the same formula has sum up all values of respective years, then populated the new table with these totals

For sure I am doing something wrong, but I just can't figure out where...

Many thanks in advance to whose can provide any help/hint.

expected outcomeweird behaviour

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi All,

for all those interested, root cause and solution of the issue can be found in this post: Same Formula applied on identical Tables gives different outcome

3 REPLIES 3
Anonymous
Not applicable

Hi All,

for all those interested, root cause and solution of the issue can be found in this post: Same Formula applied on identical Tables gives different outcome

Super User

@Anonymous , Use summarize

example

summarize(Table, Table[Date], "2020", calculate(sum(Table[Value]), filter(Table, Table[Year] =2020) )
, "2021", calculate(sum(Table[Value]), filter(Table, Table[Year] =2021) )
, "2022", calculate(sum(Table[Value]), filter(Table, Table[Year] =2022) ))

Anonymous
Not applicable

@amitchandak

thanks for your reply; however, though your solution works for different purposes, I don't need the years' totals but all the rows for the same period (see picture 'expected outcome').

In addition, please note that the same logic works with some tables but not with others, so I wonder whether the problem is not in which formula is going to use but in the data/table; here is were I am getting lost.

not the expected result

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors