Awesome!! This is what I wanted to find out and this is the video helped me to fix it. Thank you. I'm looking for more videos like this as I just have subscribed your channel 👍.
Thank you for sharing. I am having 1 problem where in two column values are the same but still while creating such dax it is showing as different. E.g column 1 = 20 Column 2 = 20 Dax to compare these two columns using if condition is showing as false.
Very informative - Thanks, we have equipments with multiple work orders (work order could be same or different - depends on time period), these equipments break down, I want to find out how many times an equipment broke down within a specific time period. How can I do that?
Bhai, By using earlier function I am getting distinct count of product name when I applied earlier function in category but when I see overall distinct count for the same dax it is different can you please help me to achieve both the distinct criteria meet in one dax
I have 2 columns where one is ID and other are values.The other column has some values that are the same, problem is ID on left can have same xxx for 2 of them and xxy for 3 of them and even xxU for 7 of them. How? Subscribed. Thanks a lot.
Dear Abhishek, I am trying to use this same but it is not working for me Unique Task = COUNTROWS(FILTER(WorkFlow_Planner_task,EARLIER(WorkFlow_Planner_task[value.title] = WorkFlow_Planner_task[value.title]))) Need your help can please ley me know if I am making any error "Error : The first argument of EARLIER/EARLIEST is not a valid column reference in the earlier row context.
@maheshgupte1495 You have your parentheses in the wrong place. You forgot the right paren after EARLIER(WorkFlow_Planner_task[value.title]) and had 3 right parens at the end. Try this COUNTROWS(FILTER(WorkFlow_Planner_task,EARLIER(WorkFlow_Planner_task[value.title]) = WorkFlow_Planner_task[value.title]))
How can we solve this question? Link of the Data set - docs.google.com/spreadsheets/d/1eBaKLGHHxyA1hD3gPa2ZlxQSsFR7G1e5AZumFvLxt_w/copy?usp=sharing - What is the percentage of customers who are repeating their orders? Are they ordering the same products or different? - For the repeat customers, how long does it take for them to place the next order after being delivered the previous one?
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
Superb! Exactly what i was looking for. Thanks.
Awesome!! This is what I wanted to find out and this is the video helped me to fix it. Thank you. I'm looking for more videos like this as I just have subscribed your channel 👍.
Thank you for sharing. I am having 1 problem where in two column values are the same but still while creating such dax it is showing as different.
E.g
column 1 = 20
Column 2 = 20
Dax to compare these two columns using if condition is showing as false.
Can we use this formula for created measures
Hi this video helped, how to find in less value in duplicate as same list
Very informative - Thanks, we have equipments with multiple work orders (work order could be same or different - depends on time period), these equipments break down, I want to find out how many times an equipment broke down within a specific time period. How can I do that?
Bhai,
By using earlier function I am getting distinct count of product name when I applied earlier function in category but when I see overall distinct count for the same dax it is different can you please help me to achieve both the distinct criteria meet in one dax
I have 2 columns where one is ID and other are values.The other column has some values that are the same, problem is ID on left can have same xxx for 2 of them and xxy for 3 of them and even xxU for 7 of them. How? Subscribed. Thanks a lot.
Subscribed ur channel bro
Thanks bro
Dear Abhishek,
I am trying to use this same but it is not working for me
Unique Task = COUNTROWS(FILTER(WorkFlow_Planner_task,EARLIER(WorkFlow_Planner_task[value.title] = WorkFlow_Planner_task[value.title])))
Need your help can please ley me know if I am making any error
"Error : The first argument of EARLIER/EARLIEST is not a valid column reference in the earlier row context.
@maheshgupte1495 I am having the same issue. Did you ever find a solution?
@maheshgupte1495 You have your parentheses in the wrong place. You forgot the right paren after EARLIER(WorkFlow_Planner_task[value.title]) and had 3 right parens at the end. Try this COUNTROWS(FILTER(WorkFlow_Planner_task,EARLIER(WorkFlow_Planner_task[value.title]) = WorkFlow_Planner_task[value.title]))
Can you help me something like this.
Sir, how to do this thing if earlier(category) not = category. Btw your content is great. Thank you
How can we solve this question?
Link of the Data set -
docs.google.com/spreadsheets/d/1eBaKLGHHxyA1hD3gPa2ZlxQSsFR7G1e5AZumFvLxt_w/copy?usp=sharing
- What is the percentage of customers who are repeating their orders? Are they ordering the same
products or different?
- For the repeat customers, how long does it take for them to place the next order after being delivered
the previous one?