Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Custom column with formula

  • 1.  Custom column with formula

    Gold Contributor
    Posted 4 days ago
    Hello,

    If I get a data-set with a custom column with a formula, how and where can I study the formula ?
    Before that: how can I display the formula?

    Thanks

    ------------------------------
    Gérard Ducouret
    ------------------------------
    Conference-PBI_200x200


  • 2.  RE: Custom column with formula

    Top Contributor
    Posted 3 days ago
      |   view attached
    If you are talking about a custom column (created in Power BI Query Editor back end):

    Go to query editor
    Find the table with the custom column.
    Find the step that creates the custom column.
    Double click the step and it will show you how it was created.
    OR
    Find the table with the custom column, right click on the table and select Advanced Editor.
    This will show you the entire M query to create the table.
    You would need to find your step in there.

    If in DAX (created in Power BI Desktop front end):
    Just click on the column in the side panel.

    Screenshots of each in the attached Word doc.

    ------------------------------
    Audrey Abbey
    SR. BI Developer/Analyst
    LeapFrogBI
    Portland OR
    ------------------------------

    Attachment(s)

    docx
    Screenshots.docx   190K 1 version
    Conference-PBI_200x200


  • 3.  RE: Custom column with formula

    Gold Contributor
    Posted yesterday
    Audrey,

    Thanks a lot for your detailed and very practical explanations!
    That works!

    Gérard


    ------------------------------
    Gérard Ducouret
    ------------------------------

    Conference-PBI_200x200