Forum Discussion

mjbywater's avatar
mjbywater
New Member
6 years ago
Solved

Column with Dynamic date changer

 

Hi I am trying to create a date column in a table where I can change the date to a specific date each month. This date column is used fore a calculation between itself and another date column in the same table

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    mjbywater , not clear .

     

    measure = maxx(allselected(Date), Date[Date])

     

    or measure = selectedvalue(Date[Date])

    • mjbywater's avatar
      mjbywater
      New Member
      6 years ago

      Hi Thank you this worked

       

      It has creeated another challenge though. I have aded this new measure to existing data table, then updated the exisiting column calculation to use this new measure, but it returns a blank, no errors though

       

      Old Coumn calculation

      Aged Months = datediff('Prophet Data'[CNI Month Creation Date],'Prophet Data'[Reporting Date],MONTH)
       
      New One
      Aged Months = datediff('Prophet Data'[CNI Month Creation Date],'Prophet Data'[Dynamic Date],MONTH)
       
      As you can see the only change is the data source, but it returns a blank