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.
Hello Anonymous
This may be a solution,
First thing to do is to linked the table with the time dimension. So you should add a time table.
Then you build your relationship like this :
After this, you could build you new Measures in the desktop like this :
Don't forget to wisely choose the column datetype (eg : Decimal number for new Measure, Integer with summary for Sales & Market Sales).
Hope it help you
Sébastien
Thanks Sebastien for replying. I would like to know where you include new measure? In the Table or in the power view.
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