compare Current year sales with last Year

[Anonymous]

Hi Guys,

        I am comparing the current year with last year sales and i used SAMEPERIODLASTYEAR for calclating the last year value but the problem is if i click the year filter say 2018 it shows the 2018 value in the current year but it is not showing the last year 2017 value. it shows the last year as blank. I had connected the data source Live through SSAS Cube.  Please help me with it and provide me an alternative solution.

[mwegener]

Hi @Anonymous,

did you solve your problem?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

hi @mwegener ,

                     I could'nt able to solve it.

[mwegener]

Hi @Anonymous ,

could you post your YTD_1 DAX formula?

[Ashish_Mathur]

Hi,

You must create a Calendar Table with a proper relationship from the Date column of your Data Table to the Date column of your Calendar Table.  In the Calendar Table, create a calculated column to extract the Year

Year = Year(Calendar[Date])

Create a slicer of Year and select any one year.

Write these measures

Revenue = SUM(Data[Values])

LY revenue = CALCULATE([Revenue],PREVIOUSYEAR(Calendar[Date])

Hope this helps.

[Anonymous]

@Ashish_Mathur  I am already having the calender table as dim date and when i used it iam still facing the same issue

YTD_1 = sum(Table1[Amount])

[Ashish_Mathur]

Hi,

Share the link from where i can download the PBI file.

[Icey]

Hi @Anonymous ,

I create a simple example and it works well.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Icey  So you saying toi create a many to one bi directional filter ????

[Icey]

Hi @Anonymous ,

It's just this relationship in the example I created. What is your data format? If you don't mind, please share me some sample data, not real data.

Best Regards,

Icey

[mwegener]

Hi @Anonymous ,

please check if the date table is mark as date table.

https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1200/lesson-3-mark-as-date-table

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener]

Hi @Anonymous ,

do you use a date table?

Could you post your DAX and a screenshot of the model view?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

@mwegener  Hi,

                        I have shared the pic of the dax and the model

YTD_1 = sum(Table1[Amount])