Forum

You're welcome. The reason I mentioned not knowing the topic is because there's no exact match at the intersection as it's between hours, so you have ...

Hi Laurent, Welcome to our forum! You can add a column to the Data table and use this formula to calculate the age of each bug: Age = IF(...

Hi Mahbub, Please try uploading the file again. After selecting your file you need to click the 'Start Upload' button and wait for the file to comp...

Hi Aleksandar, Welcome to our forum! That's an interesting question. You can't get Excel to easily generate the list of words in a sentence, but...

Hi Charles, All the suggestions made so far are valid options for you, but perhaps what we're missing is how flexible this solution needs to be. e....

Hi M, Welcome to our forum! You can use a Power Query list to generate a list of dates in a new query. Index both the dates and your data by reg...

Hi Bogdan, I probably do know Excel better than Gates these days 😀 Only because he's not so involved in its development anymore. The reason yo...

Hi Hongjia, Welcome to our forum! Please refer to this tutorial on comparing lists in Power Query for instructions on how to do this. Hope th...

Hi Bogdan, Thanks for uploading your file. You can use INDEX and MATCH to find the hours at which the thermal power meets the MW limit. First you m...

Hi Carolyn, Just change the date field the ISONORAFTER is referring to: =CALCULATE([Net Change], FILTER( ALLSELECTED('Date'[D...

Hi Bogdan, Welcome to our forum! Please upload a sample Excel file. After selecting your file, click the 'start upload' button. Mynda

Hi Carolyn, Thanks for sharing your file. There's no information as to where the opening balance is coming from, so I couldn't incorporate that, bu...

Hi Giedrius, Welcome to our forum! I'm not sure how you plan to get 100 columns from a file containing 10 but I suspect using Power Query would...

Hi Nazaar, If you haven't ever used Power Query it's going to be a bit tricky as you'll need to use loads of different techniques to clean this dat...

"Seems line you’re suggesting a one column table, is this correct???" No, not at all. There are 9 columns as listed above, and again below: Date C...