Forum

I am also very new to DAX, but what I believe you want is not to make the OpDeptID a variable. After declaring your variable for ThisDeptID then your ...

If I understand you correctly you want something like this: let Source = Table.NestedJoin(Leave, {"Name"}, Allowance, {"Name"}, "Allowance", JoinK...

Hey Karen, Fuzzy matching is your answer. I got it to work, but I think a fuzzy join of two tables would be better than fuzzy grouping. Here's a vi...

Karen, I am trying to get fuzzy grouping to work, I haven't gotten the syntax right and my version doesn't have it in the ribbon. I didn't have tim...

I see what you did there, Riny; much more simple and cleaner! I like it.

There's fuzzy matching in PQ. Without an example of the data, I'm not sure we'll be able to give adequate advice.

Hi Saliha! I came up with a SUMIFS nested inside an IF; it was fun! You will need to allow for growth, or, better yet, make it a table so the formu...

Unfortunately, there isn't a way without VBA.

Your issue is this code right here: ActiveWorkbook.SaveAs Filename:=ThisFile I don't work with saving in VBA often, but I believe what you want ...

Honestly, I would do this with a helper cell. Somewhere in your workbook have a cell with the year, you could either change it manually each year or u...

You just need a Conditional Formatting Rule. With the cells you want the rule applied to<Home Tab<Styles<Conditional Formatting<New Rule&l...

Concatenatex has a built in Order by argument. Simply use this formula: =CONCATENATEX(values(Table3[Site Name]), Table3[Site Name],", ",Table3[Site...

The path name would be ThisWorkbook.Path, and that will return the path where the file is saved for each computer.

Mynda! Thank you so much! You're creativity reigns supreme!