Full Year Measure based on Month Slicer

GarryFarrell

I am assuming that you want to show the total sales for the entire year for the selected month year.

Your year is Jul-Jun.  When I select Fiscal Year 2015 and Month Jan , you want to see the total for Month Jan 2016 as well total for the period Jul  2015 - Jun 2016.  Correct me if i am wrong.

1. Do you have a calendar table

2. If so create a column called

           MonthNumber = Month(Calendar[Date])

           [Year] = Year(Calendar[Year])

3. Create a column called

              FiscalMonth = If ([MonthNumber] >= 7, [MonthNumber] - 6, [MonthNumber] +6)

4. Create a column called

              FiscalYear = If ( [MonthNumber] >= 7, [Year], [Year]-1 ) 

5. For the total revenue by year create the measure using

         FullFiscalRevenue= Calculate([TotalRevenue],(ALLEXCEPT(Calendar,Calendar[FiscalYear])))

6. Create slicer with FiscalYear as the value and a slicer with FiscalMonth 

7. Plot your FullFiscalRevenue Figure in one chart  and plot your monthwise revenue in another chart

8. Select any FiscalYear and any FIscalMonth , you will notice that the FulLFiscalRevenue will never change irrespective of the montth selected.

If this solves your issue, please accept this as a solution and also give KUDOS.

Cheers

CheenuSing