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
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