Same as always, the weekends get added to the next Monday's results.
This causes spikes, however we can see that these spikes are going down too fortunately.
Let's remove these spike days.
Doesn't really change. Looks like they test more on the beginning of the week and by the end, it…
For this to work, we need a Calendar table, or in another name a date table.
Why isn't one of our existing columns in our data good? Because: -we need a table which contains all dates without skipping non-business days, holidays etc so all 365 days in a year.-all the dates must occur only once…
Filter Sum of profit AFTER A SPECIFIC DATE with only GUI options:
Profit is set to whole number just for readability.
--------------------------------------------------
Filter with parameter and DAX formulas:
1. Add paramter
2. Convert parameter to query for referencing it in the formula:…
Replace_from_other_column = Table.ReplaceValue(#"Changed Type",null, each [Profit] , Replacer.ReplaceValue,{"Technical_test_col"})
Filtering rows:
Grouping:
#"Grouped Rows" = Table.Group(#"Changed Type", {"State"}, {{"c_Pofit_by_state", each List.Sum([Profit]), type nullable number}})
Note: this is pretty slow when doing it from the editor, gui pivot is much faster.
