Moving 12 weeks average

DAX DAX Calculations
1

Hi awesome community. I have a visual that displays a table with a “Week Ending Tuesday” column as a date and a DAX measure for “Total Accounts Receivable”. I need to create a new DAX measure that calculates the 12-week average of the “Total Accounts Receivable” measure. Consider the date filter of financial year that starts in July. End goal will be same as the table below. Thanks in advance :slightly_smiling_face:

image

Rolling Average.xlsx (10.3 KB)

2

Bumping this post for more visibility from our experts and users.

1 Like
3

Thanks @EnterpriseDNA for this awesome community! :slight_smile:

4

Hi @ronald_balza - Please check this. has created using Index as week number but can be done using a separate Date table also.

Moving 12 week.pbix (40.8 KB)

Thanks,
Ankit J

5

Hello @ankit, I appreciate your effort. However, the solution you provided only works for your scenario where you have an index on your date table. Unfortunately, I don’t have an index on my date table, and my “Week Ending of Tuesday” column has a format of dd-mmm. This makes it difficult for me to index the column while considering a financial year that starts in July.

image
image1538×840 43.2 KB

6

Hi @ronald_balza - Please share a sample PBIX file.

thanks
Ankit J

7

Hi @ankit, I’m afraid couldn’t share the file due to confidentiality. Thanks for taking the time on this.

8

Hi @ronald_balza,

I hope this message finds you well. I understand that you are working with sensitive information and are unable to share it in the forum. We respect your privacy and appreciate your caution.

In order for our experts and members to assist you with your inquiry, it would be helpful if you could provide sample data that is not sensitive or confidential. If that is not possible, please let us know so we can explore other options.

In the meantime, you may want to check out the thread we recommended earlier, which might help you with masking your pbix file. How To Mask Sensitive Data

Please don’t hesitate to let us know if you have any questions or if there is anything else we can do to help.

Thank you

9

@ankit @EnterpriseDNA , please find attached sample pbix file. What I did was to create the dates table and connected it with your example. :slight_smile: Thanks in advance.

Moving 12 week.pbix (369.1 KB)

1 Like
10

Hi @ronald_balza - I have added Financial week number in Date table. You can use that as Index for reporting. Please check NewDate table. Let me know if further help is needed.

Moving 12 week.pbix (423.9 KB)

Thanks
Ankit J

11

Hello @ronald_balza

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you