Forum

Hi Christian, Welcome to our forum! The only way you can securely restrict access on a customer basis is with Power BI and row level security. T...

Hi Liz, I'm not sure which dashboard webinar you're referring to as there are many. However, I suspect it might be a constraint caused by a field to...

Hi Maree, Power Query will allow you to expand related tables i.e. if you select one table to import, there will be columns with related tables tha...

Hi Brian, I'm not aware of any workaround, sorry. Mynda

Hi Tom, Sort order flows from left to right and this constrains how you can sort in each subsequent column. If you sort the Project A to Z, then Ta...

Hi Mark, I'm not sure I understand what you mean, but did you know that if your user double clicks on a value cell, Excel will create a new workshe...

Hi Yifan, Welcome to our forum! The troubleshooting approach will depend on the error you're getting. Is there not some type of identifier on ea...

Hi Sue, You could use Power BI to get the data and model it with Power Pivot. Then you can 'analyze in Excel' which gives you the data model inside...

Hi Art, I'm not sure what you mean by a counter here: "a formula that dynamically changes a counter". Mynda

Hi Pav, What is the logic for filling up vs filling down? Is it related to whether the date is the first of the month or whether there are two gaps...

Hi Art, In my investment banking budgeting experience we used to just let the number formatting do the rounding on the face of the cell and allow t...

Hi Sunil, Thanks for sharing your file. I think you'll find the 'open_last_n_months' formula will become slow and unwieldy as your data grows. Righ...

Hi Sue, Welcome to our forum! You can remove duplicates from your dataset in Power Query. However, you will no doubt want to choose which record...

Hi Ahamed, You can only change the PivotTable row and column headers by typing over them on the face of the PivotTable. In your example, you don't ...

Hi Rosa, There are various time zone functions in Power Query. The one you need will depend on your data format. You can see them here. Mynda