I have calculate Beginning of Period using the below dax
BOH Inv Revenue= VAR FirstDateForPeriod = FIRSTDATE('tbl_inventory'[Inv_date])RETURN CALCULATE(SUM('tbl__inventory'[Inv_revenue]),'fiscal_calendar'[f_date]= FirstDateForPeriod)
the calculation should be different for Average of Quarter/Season/Year
For Quarter 1:
feb BOH Inv Revenue + March BOH Inv Revenue + April BOH Inv Revenue/3
For Season 1
feb BOH Inv Revenue + March BOH Inv Revenue + April BOH Inv Revenue+ May + Jun +July +Aug /7
similar for year
my present calculation is below but it just taking Feb(which start of fiscal calendar) revenue and dividing it by months,
what i am looking is take each month value and divide by months based on period.
BOH Inv Avg = [BOH Inv Revenue]/DISTINCTCOUNT(fiscal_calendar[bi_month])
Thanks in Advance.
Here are some posts for your reference.
Thanks for links. In my scenario it is fiscal calendar and every year start in feb (either on 2nd or 3rd or 4th). I can use sameperiodlastyear or DateInPeriod Founction
How can i replicate Sales12M without using Sameperiodlastyear function
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.