dax formulas

  1. B

    Dealing with (multiple) many2many relationships in Powerpivot

    I have a question about how to deal with multiple many2many relationships in Powerpivot. Here is my scenario: I have a bunch of products, where each product is assigned to at least one but potentially more categories, so for example my first table is Product Category P1 C1 P1 C2...
    • bratwoorst
    • Thread
    • dax formulas dax measure many to many pivot report powerpivot
    • Replies: 1
    • Forum: Power Tools
  2. T

    DAX IF Statement not working

    I have a data model built in Power Pivot with a few tables connected and I am trying to do a simple formula based on a few conditions. Basically calculate this formula if Scenario 1, 2, and 3 are true. Below is a view of the Error: The way it is written is like a nested IF Statement, but I am...
    • tbucki1
    • Thread
    • calculations dax formulas error if statements power pivot
    • Replies: 1
    • Forum: Power Tools
  3. J

    DAX code to count orders with crossed categories

    I've got a list of units which are being sold by a shop. Each line describes date, order number, number of units and category (A and B in this example). How can I, using just DAX measures in a pivot table, know how many orders are both in categories A and B per day? I've tried using CALCULATE in...

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