To convert Window_avg tableau expression to Power BI

[asdf1608]

I'm trying to convert the Tableau Expresions to Power BI.

How to I do this window_avg in power BI.

First I got the count of the column "Profit"

then used that calculated field to find the Window_avg

WINDOW_AVG([calculation2], 0, 7).

The result is 

How do I get this in power BI.
I have attached the PBI File.

sample.pbix.

Help in this is needed.

Thanks in advance

[lbendlin]

Same way. Use the WINDOW function to create your filter context and then apply your aggregation (AVERAGEX in your case)

[asdf1608]

Can you type this window_avg for the above scenario. I tried using yours but it didn't work. I have screenshot the expected result and the PBI file for reference.

Basic concept is 

1)to get the distinctcount of the column "Profit"

2) To find the Window_avg for that distinctcount column

The expected result:

The result I'm getting:

The Dax created:

The file:sample.pbix

Help in this is really needed.
Thanks in advance

[lbendlin]

Please describe exactly want you want to measure. Is it this? 

- Average of 8-day window sum count of transactions for each day in the table looking forward (0 .. +7)

[asdf1608]

Yes somewhat like that.

First to get the distinctcount of the column profit then to find the window_avg for that.
to return the average of the expression within the window

The simple explanation is to get the count of the column and to find the window_avg for that count.
I need this in the power BI. 

[asdf1608]

@lbendlin any idea about this

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...