Forum Discussion
Calulate previous year value without use function sameperiodlastyear or other functions
Hi Anonymous ,
yes. Please create a seperate Date Table.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
mwegener your solution is not working from my side,just same as for sameperiod last year
DATEADD ( DimDate[Date]; -1; YEAR ) )
this because i'm filtering the period with [monthslicer] that is a txt and not with [date] field...the result with your measure is always displaying blank ,
im using the monthslider as period selector in order to have current month selected and displaying everythime I open a report the currentt months year
Hi Anonymous
check this.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
I check your file i can see the measure the check year month is the= today but how I can use in order to make the slicer selected automatically the yes month year today?