Forum Discussion
dakins
Helper II
Helper IIDax issue - Multiple conditions on date data
Hello All, I need help with my dax. In my data set, I have: Type - New, return, or seasonal customers Subscription level - Gold, Silver, Bronze, Diamond Sub - Start and End date. Goal...
dakinsHelper II
Helper IIAhmedx, thank you.
The dax worked using the sample data set however when tested in my live data, it didn't work as expected.
In real world situation, customer 500 may have multiple transactions up to 5 or 6; hence the the dax has to tie every gold or bronze to its next seasonal sub.
P.s - condition - Everytime a new or returning customer subs with level gold or bronze the system automatically assigns their next type to seasonal.
| Invoice no | Customer ID | Type | Sub level | Start date | End date |
| 99 | 500 | New | Silver | 09/1/2020 | 11/1/2022 |
| 100 | 700 | New | Silver | 11/2/201 | 11/20/2021 |
| 101 | 500 | New | Gold | 8/1/2022 | 8/30/2022 |
| 103 | 500 | Seasonal | Diamond | 03/02/2023 | 03/30/2023 |