power pivot 2016 and 2019

  1. N

    Filter Calendar dimension table based on fact table value

    Hi All, I would like to ask your help to find a solution of the following case. I would like to get the minimum Calandar[Date] value which is equal or greater than TransctionPast[FirstValid] date. Here are the relationships: I created the following measure but it just uses a lot of RAM...
  2. G

    Creating Measures (or DAX?) in Power Pivot

    Hello, I'm looking for some guidance with if and how I could use measures to help me create some enhanced pivot tables. I have detailed a couple of specific questions in the document here (in red text in the Sheet: Pivot Test): s666-PQ-Impact system 2019.11.15a-ver4.xlsx But to summarise I'm...
  3. G

    Efficient way to convert table into database friendly data

    Hello, To help build some effective power pivot tables, I *think* I need to convert my data from Format A to Format B (demonstrated below). You can also see my spreadsheet that my data currently feeds through into Format A in sheet number 5. If I wanted to translate sheet 5 into a format like...
  4. S

    Countifs based on another tables components

    I have two tables one of them contains a particular's distinct values as a primary key. and another table consists the same particular's multiple values for different dates along with few more details. now based on some conditions i want to bring the outcome count to the first table for further...
    • SageTeamZZ
    • Thread
    • countifs july power pivot 2016 and 2019 table working
    • Replies: 5
    • Forum: Power Tools
  5. L

    No Table Import Wizard

    When I go into Power Pivot in Excel 2016 and Excel 2019 and select Get External Data From Other Sources I get nothing, no Table Import Wizard. Any ideals why? Thank you!
    • LDale
    • Thread
    • excel from other sources get external data power pivot 2016 and 2019 table
    • Replies: 1
    • Forum: Power Tools

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top