Forum

Hi Cindy, Where does the raw data come from? You say a file, so it's not in Excel to start with? What generates the file? Is it always in this...

Hi Marsil, Please see the attached file which is based on some code from I can't really test this for you as I am not connected to your Exchang...

Hi Stephan, You could wrap the function that produces a 0 in an IF and display an empty string =IF(MIN(IF(A7<=$BG$2,IF(AL7:AO7>0,AL7:AO7,"...

Hi Mido, Welcome to the forum. On the face of it this looks like something I can help with but I'm missing some important information. Please...

Hi Amar, Yes Power Query is a fantastic tool but for this problem you don't need to use it. You can achieve what you want with functions : =IFE...

Hi Nicole, You could try the attached code which works for the 4 sections you currently have in the document. If the maximum number of tables unde...

Hi, I took your source data table and copied it to another sheet called New Data. I removed blank columns. In the source data table I added a new...

Good job. Thanks for letting us know.

Hi Sholtan, Please post the solution so that others may learn. regards Phil

no worries 🙂

Hi David, Yes they can. In fact you really need to know Power Query and Power Pivot to get the most out of Power BI. You can find out more from...

Hi Stephan, The answers are: 1. Complete the IF statement by providing an answer if false, which is just an empty string "", so in C7 =IF(A7&...

Hi Moutaz, The best layout is a tabular format where there is a column for every type of data or 'thing to be measured' and a row for each record o...

Hi Stephan, You can use INDIRECT to reference the year in Column A, for example in D6 you could have =INDIRECT(TEXT(A6,"yyyy")&"!$V$32") ...

Hi Adam, Please see attached and compare to your solution. After unpivoting the date columns, I've grouped by Country and Date to give the final...