Forum

Hi Riny, Thanks for helping out. Please try uploading your file again. You need to click the 'Start Upload' button after selecting your file, then ...

Hi Bruno, I suggest you always have some dummy data in your data model that you can use if the current month data is empty. It likely only needs to...

Hi Else Marie, You can use a nested if formula: = if [Type] = 1 then [Date] else if Date.DayOfWeek([Date], Day.Monday)>5 then Date.AddDays([D...

Hi Paul, Please start a new topic for a new query as this is more likely to get an answer than burying it on the bottom of an old post. I've moved ...

Hi Pooyeh, Welcome to our forum! PivotTables do not respect the sort order of the source data. By default they sort in alphabetical order based ...

Hi and welcome to our forum. You can add a column to your table to calculate the running average per fund using the AVERAGEIF function. Note: your ...

Hi Tam, Welcome to our forum! That's a big task ahead of you, but not impossible 35 metrics is a lot to fit in a one page dashboard. Maybe Spa...

Hi Matthew, Thanks for sharing your file. There is something preventing your date fields being grouped. I'd say the Pivot Cache is somehow corrupte...

Hi Bruno, If the final leads table contains unique IDs then it can have a direct relationship with the Ramplus table allowing you to filter Ramplus...

How about rounding to 1 decimal place then?

Hi Bruno, It's great to hear you're enjoying our site and content! Thanks so much Thanks for explaining the data in more detail. It helps under...

Hi Paul, The problem you're discovering happens when Excel converts values to binary and back again. Sometimes referred to as a floating point. ...

Hi Bruno, Please watch lesson 6.07 of the Power Pivot course which explains how to relate multiple fact tables and which fields must be used in the...

Thanks for clarifying. You can use this formula: =SUM(INDEX(F2:F32,MATCH("Yom Kipur",G2:G32,0)-1):INDEX(F2:F32,MATCH("Yom Kipur",G2:G32,0)+1)) Obv...

Hi Lea, It's a bit hard to follow your example as I'm not sure where you got 8.5 from because that's 3 days before Yom Kipur i.e. on the 13th Septe...