Forum Discussion

CRBam's avatar
CRBam
Frequent Visitor
8 years ago
Solved

Find associated row in Fact table

Hi, I am trying to create a calculated field in my data that will let me know if a policy has been renewed.  In my fact table there is a unique polID, and a unique ParentPolID.  Each term should have...
  • CRBam's avatar
    CRBam
    8 years ago

    I posted a solution to a different problem, my apologies.  I will post that separately so others can find it.  I have decided to address this through the SQL source instead of Power BI. I don't have any caluclations or code because I don't even know where to begin.

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

CRBam,

Could you please share sample data of your table that can be copied and pasted to us? And also please post expected result here based on your sample data so that we can provide you appropriate dax.

Regards,
Lydia Zhang

CRBam's avatar
CRBam
Frequent Visitor
8 years ago

I posted a solution to a different problem, my apologies.  I will post that separately so others can find it.  I have decided to address this through the SQL source instead of Power BI. I don't have any caluclations or code because I don't even know where to begin.