Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

return a date based off a QTR column

Hi all,

 

I am trying to create a DAX formula that will return the renewal date based off a specific quarter & I am not sure if I should use CALCULATE or not.

 

heres the situation: I have two columns: One is renewal date & other is QTR renewal date. I need to return the renewal date based off a QTR renewal date filter. for example 

 

QTR 1 = Renewal date for QTR 1 

QTR 2 = Renewal date for QTR 2 etc. 

 

would Calulate(values(table[date], table2[QTR] = "Q1") work?

 

thank you!

Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Assume you have Date table, where you have Qtr Value with Date

     

    Calulate(values(table[date], table2[QTR] = "Q1")

     

    New column in table from date table

    Date= maxx(filter('Date', 'Date'[Qtr] ="Q1") , 'Date'[Date])

     

    or

     

    Date= maxx(filter('Date', 'Date'[Qtr] ='Table'[Qtr] ) , 'Date'[Date])

     

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Assume you have Date table, where you have Qtr Value with Date

     

    Calulate(values(table[date], table2[QTR] = "Q1")

     

    New column in table from date table

    Date= maxx(filter('Date', 'Date'[Qtr] ="Q1") , 'Date'[Date])

     

    or

     

    Date= maxx(filter('Date', 'Date'[Qtr] ='Table'[Qtr] ) , 'Date'[Date])

     

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.