Last seen: Jul 7, 2026
See attached!
Not sure what you want to do with it but the following query will generate one large table with 3630 rows. But it's not pretty. Just point the Source...
Please have a look at the attached file and see if it does what you need and if you can replicate it in your own. I didn't use a Slicer but the fil...
Glad I could help!
Please have a look at the attached file where I added a basic query that only involves clicking in the user interface. No M-coding required.
Good to see that you were able to figure out most things yourself. That's the best way to learn! With regard to replacing the coalesce function you...
I added a query that does what you ask for. Ikept it very basic and didn't do anything to make it any pretty. See if you can follow the steps and ...
Hi Linda, please see attached. I added another pivot table sharing the same pivot cache, returning only the min and max for Period Date. Then I add...
Could you upload a file the contains the work that you have done already? Otherwise we would have to recreate something ourselves and guess what you a...
The answer is here.
No file was attached. Please try again. Press the 'Start upload' button before you submit your reply.
The problem is that the dates in the header row of a structured table are in fact text whereas the Start and End dates in E7 and E8 are real dates. So...
Assuming that your data sits in range A2:G8 there are several ways to achieve that. =COUNTIF(INDEX(B2:G8,MATCH(A12,A2:A8,0),),1) or =SUM(--(X...
Would be easier to help if you could upload a file with some data that resembles your real data.
Best is to import the CSV, either via Power Query or the legacy text wizard. to avoid issues as you describe, do not open a CSV file directly in Excel...