Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

DAX help

i have some list of opportunities which has Anticipated Win date, see below i want to create a coloumn which subtracts (Anticipated date-Current date)[Note: current date dax should be used] and giv...
Need Help
Show and Tell
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi vjnvinod ,

     

    We can create two measures in this table visual to meet your requirement:

     

    Date Counts =
DATEDIFF ( TODAY (), MIN ( 'Table'[AnticipatedWinDate] ), DAY )

     

    Status =
IF (
    [Date Counts] < 0,
    "Lapsed",
    IF (
        [Date Counts] <= 30,
        "0-30",
        IF (
            [Date Counts] <= 60,
            "30-60",
            IF ( [Date Counts] <= 90, "60-90", "More than 90" )
        )
    )
)

     


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi vjnvinod ,

 

We can create two measures in this table visual to meet your requirement:

 

Date Counts =
DATEDIFF ( TODAY (), MIN ( 'Table'[AnticipatedWinDate] ), DAY )

 

Status =
IF (
    [Date Counts] < 0,
    "Lapsed",
    IF (
        [Date Counts] <= 30,
        "0-30",
        IF (
            [Date Counts] <= 60,
            "30-60",
            IF ( [Date Counts] <= 90, "60-90", "More than 90" )
        )
    )
)

 


Best regards,