Help Variable date measure

Georgetimes 

ok i think i got you . 

create a table to store this data as follow :  ( example  name : Discount_tbl)

let us say , discount 10% between 2023-01-01 and 2023-01-10 

then your table would be as follow : 

date                   discount                     discount_status

2023-01-01       0.1                            with discount

2023-01-02       0.1                            with discount

2023-01-03       0.1                            with discount

2023-01-05       0.1                            with discount

.....

2023-01-11        0                              without discount

from here, you should have a dimdate which should be linked to this table .

A dimcustomer  =  distinct(table_name[customer-column]) ( you can use this to create w dimcustomer if you dont have it in your model ) . 

and your table : 

Customer   |         Booking Date       | Booking Reference

A                               01/01/2024                    ABC1

A                                02/01/2024                    DDD1

A                                7/01/2024                     4567

B                                10/02/2024                    CDB2

from here, you can create a calculated column in your table : 

discount_status =  related ( discount_table[discount_status])

now you can drag and drop your columns into the visual and it will show what you want . 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos 👍🫡