'Flag everytime when ID change date DAX
I have table where with orders, articles belonging to orders and their shipping dates. What I want to do is, flag every time when shipping date changed or (when all dates for OrderID are the same) flag only once.
I tried to use calculated columns wrote in DAX, like nextdate, prevdate, nextorder, prevorder and reffer to them, but it doesn't work
I would appreciate every tip how to solve my prblem. Thanks!
| OrderID | Article ID | Shipping date | Flag |
|---|---|---|---|
| 123 | 1 | 01.01.2012 | 1 |
| 123 | 2 | 01.01.2012 | 0 |
| 123 | 1 | 02.01.2012 | 1 |
| 1234 | 12 | 15.03.2012 | 1 |
| 678 | 12 | 25.05.2014 | 1 |
| 678 | 345 | 25.05.2014 | 0 |
| 678 | 567 | 25.05.2014 | 0 |
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|