Previous week sales out of weekly data table
Hi, i have this data table of WEEKLY sales (by week number): i have a measure of Sales = sum(Quantity), i wish to create : 1. a measure of sales for the previous week (please notice the situation that the previous week for week1 is week52/53 of the previous year). 2. a measure of average sales UNTIL the previous week (exc. the current one) thanks in advance, Amit
Get Previous year from selected year
Hello, Need help please ! I need to get value of previous year depend year select with a slicer. When I select 2021 I want to see value for 2020. how can I do that ? I try to use SELECTEDVALUE : CALCULATE(sum(value), YEAR(date)=SELECTEDVALUE(Col1)-1)... Thank You
how to get the previous value taking into account other columns as a filter
Date Value Type Category 1/1/2020 10.1 1 A 1/15/2020 10.2 2 A 2/2/2020 10.3 2 B 2/17/2020 10.4 2 A I have an table like that and I need to get the value before taking into account the columns Type and Category. Realize that I don't have values for every day. For example, if I'm analyzing the day 2/17/2020, the value is 10.4, type 2 and Category A. The Value Before this one has to be of the same type and category, so we need to take the 10.2 of the day 1/15/2020.
Find MAX Date from previous records with the same ID
Hello everyone, I could need some help wiht the DAX formular for a new calculated table column. My goal is to get the last datetime for a specific filter within the same table. My query is working fine with a small amount of data but it quickly runs into performance issues (OOM & Time). For a better understanding of my goal you will find example data, the expected output and my current query below: Given Table: TaskID Start DateTime End DateTime ... ... ... 222 19.02.2020 06:54:47 19.02.2020 06:57:09 222 19.02.2020 06:57:09 19.02.2020 07:01:12 333 19.02.2020 06:58:52 19.02.2020 07:02:00 222 19.02.2020 07:05:15 19.02.2020 07:10:46 444 19.02.2020 07:12:41 19.02.2020 08:11:57 222 19.02.2020 07:13:33 19.02.2020 07:17:14 444 19.02.2020 08:11:59 19.02.2020 08:16:42 ... ... ... Expected Output for the new column "Previous EndTime": TaskID Start DateTime End DateTime Previous End DateTime ... ... ... ... 222 19.02.2020 06:54:47 19.02.2020 06:57:09 19.02.2020 06:53:23 222 19.02.2020 06:57:09 19.02.2020 07:01:12 19.02.2020 06:57:09 333 19.02.2020 06:58:52 19.02.2020 11:23:48 18.02.2020 17:52:45 222 19.02.2020 07:05:15 19.02.2020 07:10:46 19.02.2020 07:01:12 444 19.02.2020 07:12:41 19.02.2020 08:11:57 19.02.2020 06:32:11 222 19.02.2020 07:13:33 19.02.2020 07:17:14 19.02.2020 07:10:46 444 19.02.2020 08:11:59 19.02.2020 08:16:42 19.02.2020 08:11:57 ... ... ... ... Currently in use DAX: Previous End DateTime = CALCULATE( MAX('Table'[End DateTime]), FILTER( 'Table', 'Table'[TaskID] = EARLIER(TaskID) && 'Table'[End DateTime] <= EARLIER('Table'[Start DateTime]) ) ) Additional Information: The "Previous DateTime" has to be from the same TaskID. The "Start DateTime" does not have to be equivilant to the "Previous End DateTime". The gap between "Start DateTime" and "Previous End DateTime" can be 0sec but it could also be a gap of more than a month. For the column "Previous EndTime" i can't use a measure because it shouldn't be affected by any additional filters and I have to do further calculations (e.g. difference between "Previous End DateTime" and "Start DateTime"). I'm pretty new to PowerBI and DAX, so I would be happy and thankful for any information, help, advices or a new perspectiv to solve this problem.
Previous period (not month) active users
I was working on cohort analyses and created periods for retention analyses. The period column in datasheet was calculated through the Invoice date. Now I need to calculate churn rate % for this I need the previous period (not month) active users. Data attached for your reference
