Calculate Same Period Last Year & Previous Period sales by Using Fiscal Year - quarter Combination

[Yaswanth1997]

Hii , 

I Had Created a Fiscal Calender table with Fiscal Year-quarter Combination Column

& I had a sales Column in my Master data Table 

I want to get Same period Last year & previous period sales by Using Fiscal Year-Quarter Combination

can i get a help from Anyone Please

[Jihwan_Kim · Accepted solution]

Hi,

I assume starting month of the fiscal year is March.

I am not sure how your calendar table is structured, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Sales total: = 
SUM( Sales[Sales] )

Sales same period last year: = 
CALCULATE (
    [Sales total:],
    OFFSET (
        -4,
        ALL ( 'Calendar'[Fiscal Year-Quarter], 'Calendar'[FQuarternYear] ),
        ORDERBY ( 'Calendar'[FQuarternYear], ASC )
    )
)

Sales previous period: = 
CALCULATE (
    [Sales total:],
    OFFSET (
        -1,
        ALL ( 'Calendar'[Fiscal Year-Quarter], 'Calendar'[FQuarternYear] ),
        ORDERBY ( 'Calendar'[FQuarternYear], ASC )
    )
)

[Jihwan_Kim · Accepted solution]

Hi,

I assume starting month of the fiscal year is March.

I am not sure how your calendar table is structured, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Sales total: = 
SUM( Sales[Sales] )

Sales same period last year: = 
CALCULATE (
    [Sales total:],
    OFFSET (
        -4,
        ALL ( 'Calendar'[Fiscal Year-Quarter], 'Calendar'[FQuarternYear] ),
        ORDERBY ( 'Calendar'[FQuarternYear], ASC )
    )
)

Sales previous period: = 
CALCULATE (
    [Sales total:],
    OFFSET (
        -1,
        ALL ( 'Calendar'[Fiscal Year-Quarter], 'Calendar'[FQuarternYear] ),
        ORDERBY ( 'Calendar'[FQuarternYear], ASC )
    )
)

[Yaswanth1997 · Accepted solution]

Thanks a Lot Sir , 

[Yaswanth1997]

Hii Power BI Community , 

Please Help me Out of this Scenario, 

I had a data which includes address Field & Establisted date 

& the Requirement was i want to show all addresses in Global map based on Play Slicer 

( Which Means the Addresses need to be Shown based on date )

But the Problem is Play axis will filtering One date to another date 

But My Requirement was i want 

( Eg: if i have year : 2020 to 2023 then from 2020 to cummulatively the addresses need to be shown in Global map )

anyone please help me out this case How to do ????