locked
View Calculated Columns in Power BI Designer RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    If I create a calculated column in Report view using Dax, how can I view it for debugging?  Not a chart, but the actual new column itself?

    So if ColC = [ColA] + [ColB]

    How do I see ColC?

    Thanks.


    • Edited by TheDon16 Tuesday, July 14, 2015 7:11 PM
    Tuesday, July 14, 2015 12:32 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Choose the table visualization, that will present the information in the column, no chart.  So, choose the visualization and then two icons will appear in the upper left, just outside the visualization. Hover over the top one and it will say "Change visualization type", click it and choose 6th one up from the bottom that looks like an Excel worksheet. In the field list to the left, click your new column. It will be under whatever data table was in focus when you created your new column.  This area may be collapsed so look all the way to the left of the report area and you might see a "Fields" and "Filters" listed vertically, there will be an arrow icon just above them, click that to expand the area.

    If this isn't the answer, I am going to need some more to go on.


    Wednesday, July 15, 2015 2:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Figured out what to do...

    If I also drag in the ID for the row then I see all values.

    Thanks.

    • Marked as answer by TheDon16 Thursday, July 16, 2015 1:57 PM
    Thursday, July 16, 2015 1:57 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Just below the ribbon above the report. Click on the field from the field chooser on the right and the formula will appear there and you can edit it.
    Tuesday, July 14, 2015 1:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I want to see the new column itself, not the formula.
    Tuesday, July 14, 2015 7:05 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Choose the table visualization, that will present the information in the column, no chart.  So, choose the visualization and then two icons will appear in the upper left, just outside the visualization. Hover over the top one and it will say "Change visualization type", click it and choose 6th one up from the bottom that looks like an Excel worksheet. In the field list to the left, click your new column. It will be under whatever data table was in focus when you created your new column.  This area may be collapsed so look all the way to the left of the report area and you might see a "Fields" and "Filters" listed vertically, there will be an arrow icon just above them, click that to expand the area.

    If this isn't the answer, I am going to need some more to go on.


    Wednesday, July 15, 2015 2:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Unfortunately this appears to show only the distinct values not the actual column itself.

    Even if I check "Do Not Summarize" it is only a column of distinct values, not the full column that was created.

    This seems like a BIG deficiency to not be able to view a calculated column...

    Impossible to debug or even check if complex expressions are working correctly.


    Wednesday, July 15, 2015 9:05 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You're going to have to give me some help here understanding what you are trying to accomplish. What do you mean by "view a calculated column"? A calculated column is a formula and you can see the formula. A calculated column's formula resolves to values, and you can see the values. What am I missing that you can't see?

    Are you saying that you want to see a single value for the calculated column sort of what you see in Excel in the calculation area? If that is the case, just put your column in your table and nothing else.

    Wednesday, July 15, 2015 1:01 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Very simple... In Power Pivot if I create:

     ColC = [ColA] + [ColB]

    I can actually SEE the whole of ColC.  In BI Designer I cannot?  

    For non-trivial expressions it is important to see they are working as intended before blasting off incorrect reports.

    If I have to go back to Power Pivot or Excel all the time to do this then this becomes a lot less interesting of a tool.

    I could use Query mode I guess but then I have to work in M and not Dax.  Again, not a great way to set this up.


    Thursday, July 16, 2015 10:32 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    OK, I answered this already several times, but let me make it clear.

    Go to your Dataset and click it. You should have a completely blank page. Over on the right, you should see your fields in your dataset and a little calculator next to your calculated field. With no other fields checked, check your calculated field "ColC".  It will probably show up as a bar graph. Hover over the bar and you will see the total value. Select the visualization and in the upper left, switch it to a table.

    Right?


    Thursday, July 16, 2015 12:13 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I've tried this and as I already answered... this only shows the distinct values, not the column itself.

    It does this for any column (calculated or not) that you show as a table and choose "Do not summarize".   

    Try for yourself and see.

    Thursday, July 16, 2015 1:50 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Figured out what to do...

    If I also drag in the ID for the row then I see all values.

    Thanks.

    • Marked as answer by TheDon16 Thursday, July 16, 2015 1:57 PM
    Thursday, July 16, 2015 1:57 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Ah, so I was no help at all. >sigh<
    Thursday, July 16, 2015 1:59 PM