Forum Discussion
help..calculate Previous year total based on custom dates
Hi, srk_powerbi
Thank you for your feedback.
I am not quite sure how your whole data model looks like. But by only seeing this sample, I think one of many ways to achieve this is to create an inactive relation ship with 'Date Table'[previous Yr Fiscal Date] and 'sales table'[date] like the below.
Please check the link down below.
Sales Previous Yr Fiscal Date =CALCULATE (SUM ( 'sales table'[sales] ),USERELATIONSHIP ( 'Date Table'[Previous Yr Fiscal date], 'sales table'[date] ))Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
HI Jihwan_Kim thanks fo rreply.
The above solution is working fine. However, i have a question, I see there is no relationship set up between two tables, so dont we need any relationship between tables? Ideally i need to have relationship set up between This yr date field in date table a date field in sales table because i have other measures that i need to create. But when i set up relationship its not working, when start date and end date in date slicer is same.
i have 1 to many relationship. Can you help.
Hi, srk_powerbi
Thank you for your feedback.
I am not quite sure how your whole data model looks like. But by only seeing this sample, I think one of many ways to achieve this is to create an inactive relation ship with 'Date Table'[previous Yr Fiscal Date] and 'sales table'[date] like the below.
Please check the link down below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM