Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

passing date slicer value in calculated column

Requirement:   Start of Period and End of Period are based on user selection Eg: Q3 2021 ( start of period: 1/7/2021 & End of Period 30/9/2021)   I have to create calculated columns as below   ...
Need Help
halfglassdarkly's avatar
halfglassdarkly
Icon for Responsive Resident rankResponsive Resident
4 years ago

Try creating these as measures instead of calculated columns. Calculated columns aren't going to inherit filter context from your slicers via your measures.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I cannot use column names in my measure right?

    Age of Pending Claims = IF(TrusteeClaimsList_Received[LeadLagReceivedDate] <> BLANK()

    && ISBLANK(TrusteeClaimsList_Received[LeadLagDecisionEndDate]),

    DATEDIFF(TrusteeClaimsList_Received[LeadLagReceivedDate],[End of Period],DAY),BLANK())

     

    Can you please show me?

     

    TrusteeClaimsList_Received[LeadLagReceivedDate]  this is a column from table 

    How can I use this in Measure ?