Forum

Glad I could help, Tom

Hi Tom, I suspect this is how the table column name is formatted. Does the column named [Trailing 3-Month Average for Cash Receipts] have line brea...

If you don't have dynamic arrays, then I'd do this with helper columns. My head would explode if I had to write a Ctrl+Shift+Enter array formula for t...

Hi Aayushi, If you have Microsoft 365 you can use this formula: =FILTER(A59:U59,BYCOL(IFERROR(SEARCH(V1,A62:U98),0),LAMBDA(array,SUM(array)))) ...

In Excel we would use a stacked bar chart for this and set the fill colour for the dummy series below Salaries etc. to 'no fill'. Not sure if you coul...

Hi Keith, Power Query can only load to the current workbook. It cannot create a new workbook or load to another workbook. If you want to reuse the ...

Hi Ayal, It's difficult to troubleshoot without the file, but to be clear, if you change the formula to this: =FILTER([SprayAsistFrm.xlsx]SprayA...

I assume so. You'd have to test it to see for sure.

Hi Dana, See lesson 5.06 and use the ODC file method. Mynda

Hi and thanks for sharing your example file. However, it doesn't fully explain the request because the example numbers in the file don't match what...

Hi Yuan, You can try using tooltips for this. Drag the measure to the 'Tooltips' field in the visualisations pane. Mynda

Hi Yuan, You can try using a Power BI Custom Tooltip for this. Mynda

Hi Christine, This is a locale issue. Please see this tutorial for how to resolve it: Power Query Change Type Using Locale. Mynda

Hi Sarfraz, I'm not following what your desired result is. Can you please upload your file again showing the desired result in column E? Mynda

Hi Dieneba, The DATESBETWEEN function ignores the row filter context and simply returns the value specified in the formula. It therefore wouldn't m...