Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Sum (filter by same date)

Dear experts,   I would like to sum the sales by the same date in another table to calculate market share.   Example: Posting Date     Sales 1 Jan 16            3 1 Jan 16            2 2 Jan ...
  • Anonymous's avatar
    Anonymous
    10 years ago

    You add your measure in the Power BI desktop, not in the table. You right click and select new measure. After that, you will be able to change the name (by default it should write "measure") and enter the formula.

     

    Sébatien

  • Anonymous's avatar
    Anonymous
    10 years ago

    Anonymous if you want a monthly view you can:

     

    1) Create a calculated column (in the same table of the "NewColumn") to show the month.

     

    2) Then you can put "Month" and "NewColumn" into a visualization, and it automatically recalculate the value.

     

     

    #I'M Not An Expert#

  • Anonymous's avatar
    Anonymous
    10 years ago

    I've used the FORMAT() Function to show the month's name. If you want to display something else you can change the format (ex. "mmmm") using these.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Thanks Sebastien for replying. I would like to know where you include new measure? In the Table or in the power view.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

You add your measure in the Power BI desktop, not in the table. You right click and select new measure. After that, you will be able to change the name (by default it should write "measure") and enter the formula.

 

Sébatien