I have two slicers, one with year and other with month (both required).
The idea is: When I select year and month, one colunm return the period selected and other colunm return the values from last december before selected period.
IF I selected May 2018, columns return May 2018 and December 2017;
If I select April 2016, return April 2016 and December 2015.
The actual values it´s ok.
But, when I select the period, the column Exposition Last December doesn´t work.
Can someone help me?
Go to Solution.
I'm assuming you want MTD values:
Use something like this:
Exposition Last December =
SUM ( Table[Value] );
ALL ( Table[Date] );
MONTH ( Table[Date] ) = 12
&& YEAR ( Table[Date] ) = ( YEAR ( MAX ( Table[Date] ) ) -1)
Any questions please tell me
Proud to be a Datanaut!
View solution in original post
@MFelix, it´s just I need! Tks! \o/
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!