am using below dax to pass a date selection from query 1 date table into the dax custom column, but it seems like the selection is not working, how can I manage to do this: Column1 = var reference_date= SELECTEDVALUE(Query1[FullDateAlternateKey])return DATE(YEAR(reference_date),MONTH(reference_date),1)

Anmolgan yep, my bad, sorry you should use a measure Measure = var reference_date= SELECTEDVALUE(Query1[FullDateAlternateKey]) return date(year(reference_date), MONTH(reference_date), 1)

Hi Anmolgan try a measure Measure = var reference_date= SELECTEDVALUE(Query1[FullDateAlternateKey]) return STARTOFMONTH(reference_date) or column Column1 = var reference_date= CALCULATE(MAX(Query1[FullDateAlternateKey])) return STARTOFMONTH(reference_date)

az38 It says reference date is an incorrect parameter defined

az38 can I not use this in a custom column? I have a datediff formula date works on the basis of this dax and that goes like this: Month = DATEDIFF(pcc_view_ar_aging[effective_date], pcc_view_ar_aging[Measure],MONTH) the above formula am trying to use here.

Anmolgan you are trying to implement what-if logic which described here https://docs.microsoft.com/en-us/power-bi/desktop-what-if it will work with measure try to re-write your formula as a Measure Month = var _effDate = MAX(pcc_view_ar_aging[effective_date]) RETURN DATEDIFF(_effDate , [Measure], MONTH)

How to pass date selections into custom column?

12 Replies

az38
Community Champion
6 years ago
Hi Anmolgan

try a measure

Measure = var reference_date= SELECTEDVALUE(Query1[FullDateAlternateKey]) return STARTOFMONTH(reference_date)

or column

Column1 = var reference_date= CALCULATE(MAX(Query1[FullDateAlternateKey])) return STARTOFMONTH(reference_date)
- Anmolgan
  Post Prodigy
  6 years ago
  az38 It says reference date is an incorrect parameter defined
  - az38
    Community Champion
    6 years ago
    Anmolgan
    
    yep, my bad, sorry
    
    you should use a measure
    
    Measure = var reference_date= SELECTEDVALUE(Query1[FullDateAlternateKey]) return date(year(reference_date), MONTH(reference_date), 1)
- Anmolgan
  Post Prodigy
  6 years ago
  @az38 Says the reference date is an incorrect parameter defined

Forum Discussion

How to pass date selections into custom column?

12 Replies

Related content

Custom Column

Custom Visual Highlighting/Selection stops working

Custom Column

Custom column

Variance column for Dynamically selected columns