Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Build time dependent Measures from Data source with multiple dates

I want to build time dependent measures from a data table that has multiple dates but don't know how.   The exhibit below provides a sample of the data (=Data Table) and the measures I want to calc...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

Which table is your fact tbale and which column do you want to calculate? From your description, 

What confuses me is what to do with the Paid Date and Paid Count measure and how to "link" it to the Subsription Count and the calculate the Paid Ratio (which combines the two Count measures)

Could you please offer a sample file to have a test and post your desired result if possible?

 

Regards,

Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-danhe-msft,

 

I also just noticed that one of the records (Record #3) under Data Table in the original picture is incorrect.  The dates should be 1/10/2017 and 1/14/2017 (not 1/10/2019 and 1/14/2019).  Apologies for the confusion.

 

I can try to provide a sample file, I didn't originally as I don't have permissions to upload data from my computer (given my company's security settings).  The picture I posted attempts to depict sample data (=Data Table) and results (=Measures) using a simple excel workbook.

 

Thank you again,

Mark

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-danhe-msft,

     

    I included Pictures of the pbix file ... I can't upload the pbix.  Is there a way to upload the files?

     

    The last picture shows the Paid Counts are at the same date as the Subsription Counts ...  the Paid Counts should be at different dates and based on the Paid Date.  

     

    What do you think?

     

    Thanks again for your help.

     

    Mark