Forum Discussion
Helper IIIHow to find and mark specific rows in conditional window function by DAX?
Hello everyone,
I have been stuck with this problem and I really need your help. Below I have this demo partition of my master table:
Now I have to mark 1 for all rows between VAN and LDFULL code by DAX, the rest will be marked 0. The result look like this:
I have try to combine functions OFFSET with PARTITIONBY but all I just can do is finding next move base on Serial.
Please help me, many thanks to you guys
6 Replies
- Ahmedx
Super User
watch my video i did what you want with power query
VIDEO :https://1drv.ms/v/s!AiUZ0Ws7G26RiU40AmKekZWu3wvj?e=cA5H3K
Sample PBIX file attachedhttps://1drv.ms/u/s!AiUZ0Ws7G26RiU0JufLFWKnJVFBB?e=bUD7sg
- TungNguyen_19
Hi Ahmedx
Thanks for your help, but do you know how to do this work by using DAX? Because the data is from database and I can not have credential for editing on Power Query.
- Ahmedx
if we do it in DAX, then we still need the index column. it won't work without this column
