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.

     

amitchandak's avatar
amitchandak
Super User
4 years ago

VinnieHuub ,

First Create a measure

M1= if(Max(Table[logindate]) <= selectedvalue('Date'[Date]), "Yes", "No")

 

Create a table/Enter data, with two rows  Yes, No

or a new Table

Bucket = Union(row("Flag", "Yes") , rows("Flag", "No" ))

 

Create a measure now

sumx(filter(values(Table[Custnr]) , [M1] = max(Bucket[Flag]) ), Calculate(Sum(Table[Balance] )) )

 

 

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k