Forum

Hi James, I don't have any tutorials on cohort analysis (it's a pretty advanced topic), however you might find these posts that relate to custom re...

Hi Jodi, Thanks for the file, however I presume this is not the structure of the data in the fact table. Not only is it not in a tabular layout, it...

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