Hello,
I have the following data:
I would like to know how much percentage january is of the total sales.
Solved! Go to Solution.
@Niels_T , Assume you have revenue measure =
Divide([Revenue], calculate([Revenue], allselected()) )
or
by year
Divide([Revenue], calculate([Revenue], previousyear(Dateadd('Date'[Date],1,Year) ) )
@Niels_T , Assume you have revenue measure =
Divide([Revenue], calculate([Revenue], allselected()) )
or
by year
Divide([Revenue], calculate([Revenue], previousyear(Dateadd('Date'[Date],1,Year) ) )