Forum Discussion
Line chart
Hi In line chart I want to show current year vs previous year but in my case current year we are in june means current year value is showing upto june and for year 2023 also showing upto june 2023 ...
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
Sales current year: =
SUM(sales[sales])
Sales previous year: =
CALCULATE ( [Sales current year:], SAMEPERIODLASTYEAR ( calendar_dim[Date] ) )