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

Re: SUMPRODUCT in excel but what is it in BI ?

@RvdHeijden so... you can see this table with clients and desired extra columns in the top table on the picture I've posted.

You need one measure [Total tickets]

Next two formulas is for calculated columns

Maxim Zelensky
excel-inside.pro
Highlighted
Post Prodigy
Post Prodigy

Re: SUMPRODUCT in excel but what is it in BI ?

@hohlick my apologies, ur last mail worked but i see now that did not get the result i thought i wanted.

i have a stacked column chart where i can see (per month) the number of tickets Binnen/Buiten SLA but they wanted

numbers AND %

 

I need the % in that chart as wel as the amount of tickets and i can't see to fix this with tooltips so i thought i had to use a formula but the Stacked colum chart works with 1 colum with different values like a pie chart so how can i do this ?

Highlighted

Re: SUMPRODUCT in excel but what is it in BI ?

@RvdHeijden, give us please more details about your data model.

What is the structure of the table where your Binnen/Buiten SLA columns is?

What is the structure of the table where your monthly data is? It is the same tables?

If you have a single table where the next columns exist:

  1. Client
  2. Date (or Month number)
  3. Ticket No
  4. Ticket Status (Binnen/Buiten SLA)

then there is onee solution. If you have a more complex data model, then solution could be very different.

Maxim Zelensky
excel-inside.pro
Highlighted
Post Prodigy
Post Prodigy

Re: SUMPRODUCT in excel but what is it in BI ?

@hohlick ill try to be as clear as i can (hopefully Smiley Happy)

 

I have a table 'Tickets' with the al the date colums which i need to calculate, the collums which calculate the datediff (Date A - DateB ) and the column that calculates if a ticket is 'Binnen or Buiten SLA'.

 

I want a Stacked Column Chart that shows per month the percentage (always 100% total) of the tickets that are Binnen SLA and are Buiten SLA.

 

Basically i want a Stacked Column Chart which displays (per month) the percentage of tickets that were Binnen/Buiten SLA

Highlighted
Post Prodigy
Post Prodigy

Re: SUMPRODUCT in excel but what is it in BI ?

@hohlick

Got any ideas ?

Highlighted

Re: SUMPRODUCT in excel but what is it in BI ?

Hi @RvdHeijden

sorry, missed the thread. will try to take annother look at the problem

Maxim Zelensky
excel-inside.pro
Highlighted
Post Prodigy
Post Prodigy

Re: SUMPRODUCT in excel but what is it in BI ?

@hohlick @Datatouille

 

Any ideas yet ?

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors