Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Virtual budget

Hi community, I have run a data set with sale and budget for a while and we usually benchmark with bueget and traditional YoY compare.   However, COVID-19 make last-year data an exception and ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , based on what I got, Try a meaure like

     

    Switch(true(),
    max(Date[year Qtr]) = "2021Q1" ,CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(eomonth(dateadd('Date'[Date],-1*(month(today)-1),month),0)))
    max(Date[year Qtr]) = "2021Q2" ,CALCULATE(Averagex(values('Date'[Month year]),Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , based on what I got, Try a meaure like

 

Switch(true(),
max(Date[year Qtr]) = "2021Q1" ,CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(eomonth(dateadd('Date'[Date],-1*(month(today)-1),month),0)))
max(Date[year Qtr]) = "2021Q2" ,CALCULATE(Averagex(values('Date'[Month year]),Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))
)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for solution, it's work.