Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to convert tableau dashboard to poewr BI. I am facing an isssue in converting a calculated column called window_stdev.
The formula in tableau is :
WINDOW_STDEV(SUM([Quantity 2])).
It seems to be calculating table across specific dimension by date
The result from tableau is
The formula I used in power BI :
I am attaching the excel file and poewr BI file
Help in this is really needed.
Thanks in advance
Your sample table "aa" has 213K rows, but only 18K distinct rows. What are all these duplicates?
Are you sure you want to calculate the standard deviation across three values only? That will be statistically useless.
certain id may repeat. I need the standard deviations for the window across date.
normal standard deviation is coming in power BI. But for the windows it is giving me an wrong answer
Where is this filter
@lbendlin There are no filters. As you said WINDOW_STDEV calculates across all dates for each ID.
I just used the above DAX. It might be wrong.
That's why I raised this.
I am not sure why to create DAx so that the values matches with Tableau
How do you know the Tableau values are correct?
I am not sure if the tableau result is correct. All I want is the formula conversion.
Window_stdev to be calculated across the specified dimension
WINDOW_STDEV(SUM([Quantity 2])).
It seems to be calculating table across specific dimension by date
Please help me in this
Thanks in advance
I am not sure if the tableau result is correct. All I want is the formula conversion.
Window_stdev to be calculated across the specified dimension
WINDOW_STDEV(SUM([Quantity 2])).
It seems to be calculating table across specific dimension by date
Please help me in this
Thanks in advance
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |