Forum

Hi Tony, Can you upload a sample file with your data structure?

Hi Gerard, Use this formula in Activity Plan sheet, cell H4 (then copy it down) =TRANSPOSE(FILTER(tbl_MaturityDomain[Requirement],(tbl_MaturityD...

Hi, The slicer should be CHECKED on LOCKED, to protect it from changes

Hi Thulasi, Below message editor, there is an Attachments button. Instead of an image, please upload a sample file with your data structure, it ...

glad to hear you managed to make it work Cheers Catalin

Hi Andrea, Check your profile please, you have there 2 buttons to show the topics you have started and the topics you have posted into.

Hi Peter, Welcome to our forum. Try this: Create a separate query with the initial list of files, sort the DateTime descending, then remove the ...

Hi Thulasi, For Gross Profit, should be something like this: Sales=CALCULATE(SUM(ValuesTable[Actual], ValuesTable[Category]="Sales") DirExp=CALC...

indeed, EOMONTH is the right choice. Use this in the first cell: =IF(Column(A1)>B1,"",EOMONTH(A1,Column(A1))) Drag it to the right. in A1 there ...

Hi Dilip, I doubt that VbYes gets selected without displaying the message box. Make sure that the conditions are met for the MsgBox to be displa...

Hi Andrea, Can you clarify what means "BUT there is no information transposed into the Field ranges," ? an example of the desired output will be he...

Thanks for the reference

Hi Trevor, You have to be more precise, "I can't find a way for PQ to handle this[..]" is not saying anything about the structure of the desired ou...

If you need to keep the first value, you can add it as a new column. This is how the function should look like: (I collected the first cell value i...

Can you use the formula: =CELL("filename",A1) in both Mac and Windows? Please provide the results of this function from both OS.