Will ThompsonAdminWill Thompson (Product Manager, Power BI, Microsoft Power BI)

My feedback

  1. 25 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      1 comment  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    • 726 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        57 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
      • 476 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          16 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
        • 10 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            3 comments  ·  Power BI Ideas » Adoption  ·  Flag idea as inappropriate…  ·  Admin →
            Will ThompsonAdminWill Thompson (Product Manager, Power BI, Microsoft Power BI) supported this idea  · 
          • 34 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              5 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!

            • 19 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                1 comment  ·  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!

              • 44 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  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.