Forum Discussion
SAMEPERIODLASTYEAR issue
Thank you to all who respond.
My dilema is trying to calcuate revenue by customer only for the previous year.
Using the field "year" in my salesMaster table.
I created a measure called "Revenue LY" =
My problem is just trying to use the year only and not Dates.
Any ideas?
Thanks,
BLD
Anonymous 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-TITHW/m-p/434008Hi,
What do you mean by "just trying to use the year only and not Dates"? For Date and Time Intelligence functions to work well, you must first create a Calendar/Date Table. Your measure will then be:
Revenue LY =
CALCULATE(SUM(salesMaster[invoicedRevenue]), SAMEPERIODLASTYEAR('Calendar'[Date]))Hi, Anonymous ;
I created a measure called "Revenue LY" =
CALCULATE(SUM(salesMaster[invoicedRevenue]), SAMEPERIODLASTYEAR('salesMaster'[year].[year])).Here ('year') should be deleted,I tested it,when as a plus .year and no .year ,The results are different .
Or you could try the PARALLELPERIOD .
Measure 2 = CALCULATE(SUM([value]),PARALLELPERIOD('Table'[Date],-1,YEAR))The final output is shown below:
If not, can you share a simple example and hope to output the result so that we can better understand your needs?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Anonymous 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-TITHW/m-p/434008Hi,
What do you mean by "just trying to use the year only and not Dates"? For Date and Time Intelligence functions to work well, you must first create a Calendar/Date Table. Your measure will then be:
Revenue LY =
CALCULATE(SUM(salesMaster[invoicedRevenue]), SAMEPERIODLASTYEAR('Calendar'[Date]))Hi, Anonymous ;
I created a measure called "Revenue LY" =
CALCULATE(SUM(salesMaster[invoicedRevenue]), SAMEPERIODLASTYEAR('salesMaster'[year].[year])).Here ('year') should be deleted,I tested it,when as a plus .year and no .year ,The results are different .
Or you could try the PARALLELPERIOD .
Measure 2 = CALCULATE(SUM([value]),PARALLELPERIOD('Table'[Date],-1,YEAR))The final output is shown below:
If not, can you share a simple example and hope to output the result so that we can better understand your needs?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.