Forum

Hi Scotty81, There are no formatting options for row and column fields as these are text by default. Your workaround by formatting the source data ...

Hi Nancy, The structure of your model isn't clear to me, sorry. If you're adding data to an existing table then you should be able to simply refres...

Congratulations, Maree! I always find I learn a lot more when I figure something out myself, so well done for persevering. Plus, it feels like winning...

Hi Brendan, You were close. When your calculation is iterating over rows you should use one of the X functions, like in this case, SUMX: Total C...

Hi Carmina, Welcome to our forum! Format the numbers as 'Number' so that the scientific notation isn't applied, then load into Power Query. M...

Hi Nancy, Welcome to our forum! This new sheet, does it contain the same data as other tables in your Power Pivot model e.g. is it the data you ...

Nope, sorry! I can't see the year field in the PivotTable to know what the filter context is for those measures. Can you please give me a bigger scree...

Hi Maree, It's very difficult to picture in my head what you want and I don't know what you mean by 'fx' in this sentence: "I want to be able to...

Hi Vivian, Right-click the values area of the PivotTable > Show Values as > % of parent row total. Obviously you can't create a Pie Chart fro...

You're missing the closing parenthesis for the LASTDATA function, see mine: Moving Annual Total: = CALCULATE( SUM(TransactionData[Sales]), DATESINP...

Doh! You'll have to write it the old fashioned way: =SORTBY( FILTER( FILTER(TBL_MOTH,((TBL_MOTH[#Headers]=AH1)+(TBL_MOTH[#Headers]=AI1)+(TBL_M...

Hi Lea, Please see attached. Mynda

Hi Vivian, There's no attachment. Please try uploading it again. Thanks, Mynda

SORTBY allows you to sort by a column not present in the table. With LET we can make the formula more readable and efficient: =LET( tbl,FILTER( ...

Please share a small example Excel file showing your data layout and what you've tried, so I can help you find a solution. Mynda