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

My feedback

  1. 138 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

      16 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
      AdminWill Thompson (Product Manager, Power BI, Microsoft Power BI) supported this idea  · 
    • 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 →
      • 309 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

          28 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
        • 1,307 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

            121 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
          • 783 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 →
                AdminWill Thompson (Product Manager, Power BI, Microsoft Power BI) supported this idea  · 
              • 54 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!

                • 34 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!

                  • 47 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.