Forum

Hi Mattias, The files didn't upload. After selecting the file be sure to click the Start Upload button and then wait for the grey check mark beside...

Hi Mattias, Correct, you do need a date dimension table to connect your fact tables to. Power BI can automatically create date tables based on your...

I'm not a Xero expert. You'd have to speak to them. As far as I can see the recommended way to connect to Xero is using the Odata connector they recom...

Hi Aye, Perhaps a better way to do this is with Power Query. That way any updates to the date ranges can be automatically picked up and included in...

Hi Aye, Since the fees vary from one period to the next, you have to build a table as you've done to calculate the rate x the number of dates in th...

Hi Danielle, You should be using DAX time intelligence functions for this. See file attached. Note: I used a calendar table, which is required for ...

Hi Bob, Welcome to our forum! Are you able to share your file, or at least some screenshots so we can see what you're working with? After select...

Hi Peter, Welcome to our forum! You should avoid linking workbooks using formulas because they often break unless the working you're linking to ...

Hi PB, What date should 41729 and 42625 be? Are these representing date serial numbers or something else? If you can attach an Excel file with your...

Hi Alan, Excel Online cannot yet refresh queries, sorry. You will have to open the file in Excel for the Desktop and refresh there. Mynda

Hi Vaibhav, Welcome to our forum! You can see various ways to chart variances here. It uses year on year comparisons, but they can be modified f...

Hi Susan, Welcome to our forum! Holding the CTRL key and scrolling the mouse wheel zooms in and out. Sounds like maybe you were still holding CT...

Hi Tyrone, Ok, I see what the issue is now. I wasn't following earlier, despite your detailed documentation! You need a measure that activates t...

Hi Tania, Try this: =IF(AND(C6="Datasheet",P6=""),L6,IF(P6<>"",IF(OR(C6="Drawing",C6="Document"),CONCAT(A6,"_","r",Q6,R6),""),"")) M...

Looks like this question isn't about combining datasets as the sample file already has the dataset combined. Rather, it's about extracting data into a...