Forum

If you look at the PivotTable field list you'll see these are the columns in your source data. i.e. a field in the PivotTable field list = a column in...

Hi Erika, Welcome to our forum. The columns look like they're different fields to me. In which case, you need to do this with a calculated column. ...

Hi Jan, Welcome to the forum! It sounds like a regional setting issue. Remove all changed type steps, then try right-clicking the column header ...

Not sure what happened there, Scott. It's a small file, but not that small 🙂 Here it is again.

Ah, Power Pivot Slicers work differently. For them you need to add a numeric column to the table containing your Slicer items (K-12) and set that as t...

Hi Anil, Welcome to our forum! Please upload an Excel file containing your data and desired result and explain in words what you're after as I'm no...

Hi Scott, Welcome to our forum! Please see the file attached. Note: the interest rate doesn't take into effect any compounding. This should not ...

Hi Patrick, Yes, ROW reference should be absolute. In the file you attached the formula in cell C4 is looking up B2. I also noticed that there are ...

If you want K first in the list then you need to set up a custom list with the values and their sort order: File > Options > Advanced > Gener...

Hi Patrick, This formula is handling arrays; list and ROW. You must ensure the arrays are the same size i.e. the list name should reference cells $...

Hi Shantanu, It's difficult to say without seeing your model or PivotTable structure. You need to have the Date field, Start of Month, in the Pivot...

Hi FS, I think you're all confused 🙂 If Previous year is 110,000 (in column A) and current year is 100,000 (in column B) then this is a -9% ch...

Hi Jim, If the numbers are formatted as Numbers then they will sort correctly. It looks like your source data is formatted as text, hence the sorti...

Hi Patrick, The list should have an exact match to the data in column B. In your example, the list in column C should only contain J217386W as the ...

Hi Shantanu, Each formula you mention in the table should be a measure in your Power BI model. This is a running total type of calculation, which i...