Forum Discussion

jpt1228's avatar
jpt1228
Icon for Responsive Resident rankResponsive Resident
7 years ago

Previous Custom Fiscal Period Column in Date Table

Hello, I have been working with custom fiscal weeks and periods. a Fiscal period is 4 weeks - There are 13 fiscal periods in a year. I have a DimDate table that has the typical date, year, month, day, week in year, FiscalWeek, FiscalPeriod, IsCurrentFiscalPeriod (True/False), FiscalPeriodStartDate.

 

I am looking for a way to filter a visual for the previous fiscal period based on the current fiscal period. Something like:

 

PreviousFiscalPeriod = DateAdd Current Fiscal Period -1 Fiscal Period.

 

Thanks

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support

    Hi jpt1228 ,

     

    Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.