Kenneth Barber

My feedback

  1. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
    Kenneth Barber commented  · 

    This would not work well with multiple modes. I feel like any MODE function introduced to DAX would have to return a table with a single column containing all of the modes, and then you can pick which mode you want to use. This would be similar to MODE.MULT in Excel.

  2. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  3. 403 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  4. 72 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  5. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber commented  · 

    You can replace the nested IF functions with SWITCH(TRUE,). After the 1st argument of SWITCH, you have pairs of matches and return expressions. At the end is the expression to be returned if no match is found. For example:
    Number To Text:=SWITCH(<number goes here>,1,"one",2,"two",3,"three","Number not found")

    So you can replace IF(<condition1>,<expression1>,IF(<condition2>,<expression2>,<expression3>)) with SWITCH(TRUE,<condition1>,<expression1>,<condition2>,<expression2>,<expression3>).

    You can use VAR statements to save the result of an expression that is used multiple times. You can break your formula across multiple measures to keep things neater and to be able to execute the same code multiple times under a different filter context.

    I can't see any other improvement to make to your formula without any more information, not like this is the right place to be asking for help. Try this forum instead:
    https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer

  7. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  8. 279 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  9. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  10. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  11. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  12. 70 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Power BI Ideas » Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  13. 333 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  14. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber commented  · 

    You can unpivot the table in the Query Editor before you add a calculated column. Then you can add a single calculated column instead of multiple.

  15. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  16. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber commented  · 

    The Quick Measures are like a repository of measures.
    https://community.powerbi.com/t5/Quick-Measures-Gallery/bd-p/QuickMeasuresGallery

    However, when you don't know how to write the proper expression, you are more likely to just do a Google search for your description of it rather than click through a repository.

    I'm not so sure that the SWITCH function on its own deserves a tool. What other functions or expressions would be appropriate for their own tool?

  17. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
    Kenneth Barber commented  · 

    When you use a calculated column for the values in your visual, you are creating an implicit measure and you still need to specify how to aggregate the values (sum, average, etc.). The suggested measure would have to depend on the formula in the calculated column and the aggregation being used.

    All of the aggregation functions have an "X" variant that can be used to easily replace calculated columns. If your calculated column is summed in a visual, use SUMX(<table name>,<calculated column's formula>) to replace the implicit SUM(<calculated column name>) measure.

    If this suggestion were implemented, you might do something like right-click on the calculated column, and then choose Create Measure. Then you would be prompted to choose your aggregation type. Then a measure would be created by wrapping the formula of your calculated column in one of the "X" functions.

    I'm not sure in what case a calculated table would be able to replace a calculated column.

  18. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber commented  · 

    DAX doesn't have nulls.

  19. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  20. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber commented  · 

    What do you mean by "remove HTML"?

← Previous 1 3 4 5

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.