topic Re: To convert Window_avg tableau expression to Power BI in DAX Commands and Tips

To convert Window_avg tableau expression to Power BI

asdf1608 — Thu, 01 Jun 2023 14:38:51 GMT

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

Re: To convert Window_avg tableau expression to Power BI

lbendlin — Sat, 03 Jun 2023 19:27:32 GMT

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

Re: To convert Window_avg tableau expression to Power BI

asdf1608 — Thu, 15 Jun 2023 07:59:38 GMT

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

Re: To convert Window_avg tableau expression to Power BI

lbendlin — Thu, 15 Jun 2023 21:18:14 GMT

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)

Re: To convert Window_avg tableau expression to Power BI

asdf1608 — Fri, 16 Jun 2023 08:02:15 GMT

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.

Re: To convert Window_avg tableau expression to Power BI

asdf1608 — Mon, 19 Jun 2023 14:58:55 GMT

lbendlin any idea about this

Re: To convert Window_avg tableau expression to Power BI

lbendlin — Mon, 19 Jun 2023 15:04:23 GMT

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-Forum/ba-p/963216
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/1447523