AdminWill Thompson (Product Manager, Power BI, Microsoft Power BI)

My feedback

  1. 20 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      5 comments  ·  Power BI Ideas » Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
    • 295 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        26 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
      • 1,265 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          119 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
        • 754 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            30 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
          • 18 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              3 comments  ·  Power BI Ideas » Adoption  ·  Flag idea as inappropriate…  ·  Admin →
            • 53 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                7 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →

                You can work around this with some DAX... Not ideal I realise, but take a look at my example here: https://1drv.ms/u/s!AhrHQG3fCq7Rsu0Z8MhPKuWN3nkt6A

                HTH!

              • 30 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  2 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →

                  It's not a complete solution, but there some advanced Join options when you use the Merge function in Query Editor... You can do inner/outer, left/right/full and anti joins. We don't support multi-joins, but you can create bridging tables and use those. We don't support other operators than "=", but we don't hear many requests for it so until this gets lots of votes we probably won't be able to prioritize that work. Hope that helps!

                • 46 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    7 comments  ·  Power BI Ideas » Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →

                  Feedback and Knowledge Base

                  Ready to get started?

                  Try new features of Power BI today by signing up and learn more about our powerful suite of apps.