Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
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 outcomeexpected outcomeweird behaviourweird 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 

 

 

View solution in original post

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 

 

 

amitchandak
Super User
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) ))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
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 resultnot the expected result

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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