Search results

Hi I was wondering if it is possible to create some sort of DAX formula that will allow me to be able to select one date from a Date Timeline Slicer, and it will filter two different date columns. What I need essentially (see attached report), is to be able to select a date, and the pivot table...

Hi @Belleke ... just a quick question on this please? (Not sure if it's obvious from the code), but I'm trying to get the result from clicking on LB_11 to determine which directory to go to for the PDFs. LB_11.Column(1) will be a Team Leader's name (eg: "Team Alice"), so what I want is the...

Failing that, can the mailfrm be populated and exectuted as part of the original macro? @Belleke

Is there then a possibility of the pdf selection and email address being selected and "Mail" button pressed in a Slicer loop through? Or is that just dreaming?

This is excellent thank you.

Is this not possible? Then I can move on to trying something else.

Hi, I have managed to find a way of printing all my slicer selections to PDF and store them into a file location using VBA. Attached is my file. I also believe there is a way to have a macro that will distribute the email to each advisor as part of the macro. I tried combining an emailing macro...

Anyone can help with this??

Hi, I have developed a dashboard that links my entire data model using Power Pivot and gives a nice range of tables as an output. My question is, is it possible to create a macro button that will select each item in the slicer, and then print it. I have done this in the past using a dropdown...

Hi I am trying to put a formula together that will sum up a Total of Ancillary Revenue based on a List. Now I could do it by adding up all the values in the cells like my code below (where my list of possible values is in Cell $S$61 downwards...

Hi, I'm trying to achieve a list of my best selling product based on criteria from Slicers selections. I made a Named Range of all my Slicers ("Slicers1") that applies CUBESET to each slicer name. Ive then created a Sort of top selling tours by doing this formula in cell $Z$2...

Thanks again for the help :) I feel like a whole new chapter in my life is about to begin with DAX formulas. It's only a few months ago I had everything on sumifs!!

Hi, I am trying to show two figures at the same time and feel like I've tried everything and researched everything but cannot find an answer (so don't know if this is possible or not). I want to use my slicer to pick a date range to give me total sales for that period, but then I also want...

That's amazing!! I went with option 1 and it has worked a treat! Thank you :)

I was wondering if someone could help me figure out how to solve a query in PowerPivot, where I want to look at the outcome of 2 fields, and based on the two items returned, create a category. From my Data Model on the FlightsTable I am trying to identify what category a flight falls under UK...

I'm a bit lost and I've probably missed a step somewhere. I am trying to link my BookingsTable to my FlightTable. I loaded both tables into the Data Model as connections, then New Blank Query to link the two tables. The BookingsTable is all unique references. But when I build a pivot by...

thank you... sorry about this, there were blank spaces at the end of my codes so the remove duplicates thing wasnt working

Not sure how to do that.. but I can assure you there are no duplicates in [BD ABTA] on my TradeList table

Hi guys, I am trying to link my BookingsTable to my TradeList by the fields [ABTA] and [BD ABTA], but when i go to link the two, i get this message: My TradeList definely has no duplicate [BD ABTA] values. Sample file here: https://drive.google.com/open?id=15l_W1omTfghkNhBr46z8XDeVXuD8pND0...

Thanks. I'm currently attempting the method of data model/ powerpivot. Then having my dashboard built up using =cubevalue formulas. I wasn't sure whether it would be slower to do it this way as the dashboard will have formulas and slicers relating to many tables, Or if it was best to create one...

Can you advise if there is a better way of looking up the values in Column AE against the values in my 'StaffTable' rather than using the vlookup method i have done here.. or is that the correct way? Feels like it isnt?

Amazing.. thanks :)

Hi All, I have two tables, one that displays calls and one that displays bookings (file attached). I can make an assumption that bookings are only made while the person is on the phone. So can I get my calls table to show what holiday was booked and what the revenue was. The booking has to have...

Hi, I had a report with some vba attached to it that switched the pivot tables between showing number of passengers and total revenue at the press of a macro button. I have changed the pivots to data model pivots and now my vba script doesnt work. Is there anything i need to do differently...

Hi, I was wondering if the following is possible. On the attached file I want to do a true year-on-year comparison. So if I select a date period using the slicer for a departure year, it would apply those filters to pivot table one, and then pivot table two would show the equivalent period last...