Sameperiodalstyear calculation for last years same week of month

[xcrmadmin]

I have an issue that my measure for Sameperiodalstyear is not filtered to get sales of last year the same week of month period ist only calculate the month period but i was filtered to show the week of the month and it does not work.

Anyone can help me to right the measure for Sameperiodalstyear that calculates the week of the month period, not the whole month.
my report is sent every end of the week to my reporter so the measure should show the week period of the month, not the whole month. 

i have a date table and there are relationships with the salse table, and the date table i have calculated column the defines the dates similar to current week and i use this to filter to filter per week. 

[Greg_Deckler · Accepted solution]

@xcrmadmin You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Whitewater100 · Accepted solution]

This measure may solve your problem. I am using [Total Sales] for the measure to get to any time frame that is filtered for, for prior year.

Sales LY = CALCULATE( [Total Sales], DATEADD( Dates[Date], -1, YEAR ) )

Sales LY-1 = CALCULATE( [Total Sales], DATEADD( Dates[Date], -2, YEAR ) )

[xcrmadmin · Accepted solution]

hello 
thank you so much the refrences that you shared help me to catch this function 

 PREVIOUSYEAR ( 'Date'[Date] )

and my final code that solve may issue is compination between @Whitewater100 and @Greg_Deckler 

 CALCULATE ( SUM ( DIM_WON_ANALYTICS[actualvalue] ), //SAMEPERIODLASTYEAR ( 'Date'[Date] ), //DATEADD ( 'Date'[Date] , - 1 , YEAR ) PREVIOUSYEAR ( 'Date'[Date] ), 'Date'[IsWeek] = "Current Week", 'Date'[IsMonth] = "Yes" ) RETURN IF ( RST > 0, RST, 0 )

[Whitewater100 · Accepted solution]

This measure may solve your problem. I am using [Total Sales] for the measure to get to any time frame that is filtered for, for prior year.

Sales LY = CALCULATE( [Total Sales], DATEADD( Dates[Date], -1, YEAR ) )

Sales LY-1 = CALCULATE( [Total Sales], DATEADD( Dates[Date], -2, YEAR ) )

[xcrmadmin]

Hi 

thank you for your solution, but when i appy your idea the result coming fine but there are zero value instead of the actual value that should appear of previues year for 2021 (AALY) the value appear zero and its should appear 37750

i dont know what the wrong. 

[xcrmadmin · Accepted solution]

hello 
thank you so much the refrences that you shared help me to catch this function 

 PREVIOUSYEAR ( 'Date'[Date] )

and my final code that solve may issue is compination between @Whitewater100 and @Greg_Deckler 

 CALCULATE ( SUM ( DIM_WON_ANALYTICS[actualvalue] ), //SAMEPERIODLASTYEAR ( 'Date'[Date] ), //DATEADD ( 'Date'[Date] , - 1 , YEAR ) PREVIOUSYEAR ( 'Date'[Date] ), 'Date'[IsWeek] = "Current Week", 'Date'[IsMonth] = "Yes" ) RETURN IF ( RST > 0, RST, 0 )

[Greg_Deckler · Accepted solution]

@xcrmadmin You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[xcrmadmin · Accepted solution]

hello 
thank you so much the refrences that you shared help me to catch this function 

 PREVIOUSYEAR ( 'Date'[Date] )

and my final code that solve may issue is compination between @Whitewater100 and @Greg_Deckler 

 CALCULATE ( SUM ( DIM_WON_ANALYTICS[actualvalue] ), //SAMEPERIODLASTYEAR ( 'Date'[Date] ), //DATEADD ( 'Date'[Date] , - 1 , YEAR ) PREVIOUSYEAR ( 'Date'[Date] ), 'Date'[IsWeek] = "Current Week", 'Date'[IsMonth] = "Yes" ) RETURN IF ( RST > 0, RST, 0 )