Forum Discussion
Filter on the measure.
I need to create a measure that makes a calculation using the SUMX function but also has a filter, for example SUMX (table; max (year column); column1 * column2) and will also need to create a measur...
yes, to correct that what you recommend? I create a dimenssão calendar?
Sean
Community Champion
Community ChampionDo you have any other filters/slicers ON at the same time?
EDIT:
If you want to create a Date Table look here (Link by Matt)
http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/