Forum

Hi Angela, Welcome to the forum! Have you watched the session on Bullet Charts in the dashboard course? It shows you that the qualitative scale ...

Hi John, Seeing that you don't have Power Pivot. I'd use Power Query to aggregate the data the way you need because formulas are going to be overly...

Glad you got it working! You could always apply a filter to remove duplicate rows, but you'd want to be certain that a duplicate could never exist!

Hi Bax, Can you please upload a sample Excel file with your data? Thanks, Mynda

Hi and welcome to our forum! The solution here is to put your data in the correct Tabular format in a single table, not spread across multiple shee...

Hi Cedric, Sort the jockey column, then click on the race column and sort it. That will perform a 2 column sort. You should see a small 1 in the jo...

Hi Claudine, When using Time Intelligence functions, like PREVIOUSYEAR, you must use the date fields from your calendar table, not the fields from ...

Hi Corrie, Welcome to our forum! Can you please upload a sample Excel file as I'm not following your tables above as the cells are empty. I susp...

Hi Allyn, I'm not aware of any Secret Santa templates, sorry. If you're looking for a formula to randomly assign people to one another then you can...

Hi Allyn, No, you either have totals on or off for all columns. You could use some conditional formatting to hide the totals by formatting the font...

Glad I could help. If you're using MAX then this suggests that you have multiple prices for a single date and you're finding the maximum value for a d...

Hi Andrew, It's difficult to be specific without seeing your model structure, but let's say you build a PivotTable with Customer ID in the row labe...

Hi Carolyn, I couldn't open the Google link, but you can use LEFT to extract the first character in the text string. e.g.: =LEFT(E2,1)+0 The ...

Hi Anne, Yes, an IF will work. The formula below will convert both 9 and 10 digit numbers to text: =IF(LEN(A1)=9,TEXT(A1,"000000000"),TEXT(A1,"0...

Hi Chris, You could just sort the first column, then add an index column from 1. Then sort the next column and add another index column and likewis...