Forum Discussion
Anmolgan
Post Prodigy
Post ProdigyHow to pass date selections into custom column?
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 referen...
AnmolganPost Prodigy
Post Prodigyaz38
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.
az38
Community Champion
Community Championyou 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)