Forum

Try simplifying your file and upload it here directly, no links needed.

Yes, a lookup related table will work too, I thought it's a power query only solution, sorry.

Hi David, You should do that in Power Query to define age groups. See this article for a similar problem.

Hi Lannie, As described in Vlookup Multiple sheets link sent in the previous message, it is possible to create a formula to lookup a value in multi...

Hi Gayatri, Use Intersect to set the range to be monitored, this way the code will be triggered only when you change K4 or L4: Private Sub W...

Hi Melanie, Can you prepare a sample file with your code? It will be easier to evaluate what you have or generating the next numbers and saving to ...

Hi Lori, You can store the password verification result in a public or global parameter, but the problem is that these parameters are lost when an ...

Hi, Well, if you don't have PP, not many choices left. A SUMIF in Power Query can be replicated with Group By, from Transform tab, you can choos...

Hi Lannie, Try a VLOOKUP on multiple sheets, if the structure may vary.

Hi Trond, Build another measure to display BLANK() instead of zero: =IF(SUM(tblTransactions[Amount])=0,BLANK(),SUM(tblTransactions[Amount]))

Hi Luhur, If you want enhanced security, you can try to convert your excel files to executables, using LockXLS or any other conversion tools, there...

Hi, Please keep in mind that Power Query is designed for data import and transformations, not for calculations and reports. For large datasets, the...

Hi Junko, Make sure that the key columns from both tables have the same data format, if one is text and other is general or numeric, there will be no ...

Hi Linda, I am sure you know that there are differences between power BI web version and the Desktop version. You are not clear about the environme...

Hi Jason, You should remove the automatic date grouping, and add your own Year/Month/Quarter/Day columns to the original data. Best way is to ha...