Forum

Hello, In your sample file you write that in cell E5 you want the number three if the condition is false, but where does this three come from? Is i...

Hello, Isn’t it easier to use a Pivot Table to get the count or sum of each desired column for each solar system? Or enabling the total row for the...

Hello, What you want is dynamic dependent data validation lists and this link takes you to a blog post describing how to set it up. Br, Anders

Hello Hamid, Welcom to MOTH. In my view you don't need to involve Power Query to get what you want, but Power Pivot. I have created an example f...

Hello, Not sure I understand what your problem is, can you share a file with this problem? Br, Anders

Hello, If you also have the year then yes. Check out the Date.FromText function. Br, Anders

Hello, If you double click the query after getting the error you should get more details of what is generating the error. Br, Anders

Hello, See if the example in column F suits your need. There is no error handling and the formula was created in tablet version of Excel, meaning i...

Hello, It is always easier if there is a sample file, I will give it a try anyway. I am replying this from my tablet, so can’t double check in Powe...

Hello, If your data is in Excel tables and you have activated the option to show the Total Row (Table Design, Table Style Options), you can referen...

Hello, Do you have a sample file to share? That would be easier for everyone as it's then not necessary to create new file with dummy data. I as...

Hello, With synced folder you still have the data available even when not online, with mapped folder you need to be online to get the data. Br, ...

Hello, Just a question, wouldn’t custom data types be a better alternative? Br, Anders

Hello, No need for Power Query for this. See attached file for one example on how this can be achieved. Just add a new column to your table where y...

Hello, There are no formulas in your file. For simplicity, do add dates with your time, then it all works fine. Br, Anders