Forum Discussion
Tripb44
Helper II
Helper IIDate table reference for measures
I have a calculated column in my date table "IsCurrentMonth". When I try to reference that column in a new measure it does not come up as an option. I'm also not able to reference the date table wh...
Tripb44Helper II
Helper IIAmitchandak, that is what I would normally expect but is not the case for some reason. Below is what's happening when referencing the date column. Shown also is the date table for reference.
Hi Tripb44,
You can't direct use table columns in your measure expressions. Please package your field with aggregate functions or selectedvalue to extract the current value.
Calculated Columns and Measures in DAX - SQLBI
Using the SELECTEDVALUE function in DAX - SQLBI
Regards,
Xiaoxin Sheng