Forum

Hi Hava, There was no file attached but from what you describe you can use Chart Templates. If you have any problems please let me know. Mynd...

Hi Linda, In Excel 2016 they removed the Link icon from the 'Add to Data Model' icon. When you load data to Power Pivot from a table using the '...

Hi Benedikte, The map visuals will automatically resize to zoom in to the area containing data. If you want to zoom further then you could use Slic...

Hi Benedikte, Your source data should always be in a tabular format for Power BI modelling. Mynda

No inconvenience 🙂 Just better to have the Q&A in the members area for other members to benefit from. Mynda

Hi Linda, You're right, you need to consolidate the 3 sheets containing help desk ticketing data into one table, which you can then load to your da...

Hi Julian, It's odd that adding records to the table resulted in subsequent rows not getting the apostrophe. It seems to be generating inconsistent...

Hi Mey, Please use topic subjects that disclose something about the topic. 'Ask for help' doesn't help us or others identify if this topic is somet...

Hi Cele, Sorry, I don't have a video tutorial for the CELL function. I wouldn't worry about understanding it too much. You can just re-use the exam...

Hi Benedikte, You can think of referencing another query much like referencing a cell in Excel that contains an Excel formula. e.g. let's say in ce...

🙂 always love a loophole!

You're welcome, Vladimir. Glad you're enjoying it and thanks for sharing your tip. Mynda

Hi Mark, Try wrapping your EDATE fomula in the TEXT function and convert the header to text with mmm-yy format e.g.: =TEXT(EDATE([previous colum...

Hi Bill, I suspect it's something else because you can create your own measure, but you might want to give it a different name to the implied measu...

Hi Blanka, How about this Power Query formula: = if [Value] - Number.IntegerDivide([Value],1) < 0.25 then Number.RoundDown([Value],0) else...