cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Re: How to sum up and merge data from different tables in certain rows in a new querry?

@vanessafvg

 

No, not exactly.

 

What is missing is the cumulative row for the respective month. Also I want to have all 3 figures from the 3 different countries in 1 row for each single month instead showing three times the row for the same month. Are my intentions clear to you or not?

Highlighted
Helper III
Helper III

Re: How to sum up and merge data from different tables in certain rows in a new querry?

@vanessafvg

 

i keep getting shown this syntax error warning:

 

error.png

 

Can you spot the Syntax Error or have I just made a mistake while referring to a measure or table?

 

Highlighted
Super User II
Super User II

Re: How to sum up and merge data from different tables in certain rows in a new querry?

@Paddhof1984

 

is your | a ,?

 

i would write it like this;

cummulative turnover=
CALCULATE (
    [turnover 15vs16],
    FILTER ( datekey, datekey[date] <= MAX ( datekey[date] ) )
)

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Microsoft
Microsoft

Re: How to sum up and merge data from different tables in certain rows in a new querry?

Hi @Paddhof1984,

As the @vanessafvg said, the | is wrong, and the date highlighted in bule filter is wrong, you need use a table in filter. The syntax of filter is: FILTER(<table>,<filter>)

1.PNG

Please mix it using the formula @vanessafvg given. If you have resolved your issue, please mark the right reply as answer.

Thanks,
Angelia

Highlighted
Helper III
Helper III

Re: How to sum up and merge data from different tables in certain rows in a new querry?

@v-huizhn-msft

 

Hello,

 

the suggested solution is correct. But I still got the issue, that the monthly turnover is not added to each following new month. It only shows figures which seem to be added up already in total per month.

 

What I need is, that the turnover is summed up month per month until december for each specific country.

 

So it should look somehow like this:

 

JAN ($ 1.200.000,00)   FEB ($ 1.600.000,00)  MAR ($ 1.300.000,00)

 

MONTH:

 

1                                  2                                3

 

$ 1.200.000,00             $ 2.800.000,00           $ 4.100.000,00      and so on.

 

What I need is: a column where the turnover for specific countries is shown only per month and a second column where the turnover for those countries is shown always summed up with the following month from JAN - DEC.

 

In this case it seems like the suggested query is not containing this solution.

Any other ideas?

Highlighted
Microsoft
Microsoft

Re: How to sum up and merge data from different tables in certain rows in a new querry?

Hi @Paddhof1984,

Please try the formula below, and check if it workds fine.

cummulative turnover=
CALCULATE (
    [turnover 15vs16],
    FILTER ( datekey, datekey[Month] <= MAX ( datekey[Month] ) )
)

 

For more details, please refer to this blog.

Thanks,
Angelia

Highlighted
Microsoft
Microsoft

Re: How to sum up and merge data from different tables in certain rows in a new querry?

Hi @Paddhof1984,

Have you resolved your issue? Please mark the right reply as answer.

Best Regards,
Angelia

Highlighted
Helper III
Helper III

Re: How to sum up and merge data from different tables in certain rows in a new querry?

Hello @v-huizhn-msft,

 

I have solved this Problem by myself.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: How to sum up and merge data from different tables in certain rows in a new querry?

Hi @Paddhof1984,

Congratulations, could you please share your workaround or mark the help reply as answer, so that more people can find the solution easily.

Thanks,
Angelia

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors