Time comparison by average per day over two separate periods

DAX DAX Calculations
1

I want to be able to compare the average sales per day for two distinct periods.

1.the average sales over a selected time period (say last 30 days)
compared to
2.the average sales over a selected period (say 180 days)

Can you direct me towards training materials in https://portal.enterprisedna.co/ that would address this?

thanks
James

1 Like
2

@jsavage,

There’s so much overlap between the DAX time intelligence functions that there’s probably nearly a dozen different ways to do this. The two I prefer are using DATEADD or the offset functions within @Melissa’s awesome Extended Date Table.

I hope you find these helpful. Give a shout if you need any additional assistance.

– Brian

2 Likes
3

Hi @jsavage, did the response provided by @BrianJ help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

I hope that you are having a great experience using the Support Forum so far. Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!

4

Hi @jsavage, we’ve noticed that no response has been received from you since the 16th of June. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

5

Hi @jsavage, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks.