Forum Discussion
Sum (filter by same date)
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 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#
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.
Hi B129, I see your reply and thanks a lot for correcting my mistake. So my mistake is I am supposed to use related in the sales table.
Then another question will be:
In the example shown there is daily transaction (Sales) and daily market sales. How do I do it if I want to have monthly market share instead of daily market share?
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#