Forum

You're correct in your observation: when you create a calculation group in Power BI, the calculation group essentially replaces the default measure wi...

Can you go to Data Source settings, and check if Privacy level is properly set?

you're heading in the right direction. You’re leveraging a calculation group to filter your fact table ( trs smf ) based on the selected granular...

specific financial data like Year on Year (YoY) Sales Growth and Year on Year (YoY) Profit Growth are not available by default through the Stocks data...

An Office addin is in fact an embedded website inside excel, in a side panel. The code is on server, not in the addin. Anyway, it's a more c...

Macro enabled excel files will not work properly in SharePoint or OneDrive, there will be too many conflicts. Office Addin will be my choice, this...

Hi Ryan, To notify users if a file is opened in Excel Online using Office Scripts, you can create an Office Script that checks the platform and dis...

Hi Gregory, Do you have a sample file so we can see your structure?

Hi Nikos, I don't think this is something that should be handled with formulas only, you'll hit more and more road blocks ahead. Best to use macros...

Instead of pasting an image to chart, try using the .AddPicture method: ' Add the image to the chart oCht.Activate Set shp = oCht.Chart.Shapes.AddP...

Hi Peter, Before converting to Date, try replacing the "." with "-" or use the Locale date conversion, the "." date separator is not used in US, on...

Hi Lea, Looks bad enough 🙂 You still need a solution or you found it?

I am not aware of such templates unfortunately.

PDF's are messy. Usually, data is duplicated, what is in Tablexx is also in Pagexx, so you have to filter to get data only from Tables OR pages. Once ...

Hi Emmanuel, Those are not date ranges, 13-17 is a text considered a date range. I would insert 2 hidden rows above that "date range" with the real...