Forum Discussion

VinnieHuub's avatar
VinnieHuub
New Member
4 years ago
Solved

Dynamic Category based on selected date

Hi all,   I'm trying to create a new category column to an existing table, but it needs to be calculated based on a date selected by the end user.   F.e. we have this simple table called Customer...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, VinnieHuub 

     

    You can try the following methods.

    Date = CALENDAR(DATE(2020,1,1),DATE(2021,8,31))

    Measure:

    Measure = 
IF (
    MAX ( 'Date'[Date] ) >= SELECTEDVALUE ( 'Customer'[Logindate] ),
    "Yes",
    "No"
)

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, VinnieHuub 

 

You can try the following methods.

Date = CALENDAR(DATE(2020,1,1),DATE(2021,8,31))

Measure:

Measure = 
IF (
    MAX ( 'Date'[Date] ) >= SELECTEDVALUE ( 'Customer'[Logindate] ),
    "Yes",
    "No"
)

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.