Forum Discussion
Build time dependent Measures from Data source with multiple dates
Hi All -
The following post solved the issue I was having ...
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
Hi v-danhe-msft ,
Thank you for your post and clarifying question.
In the picture I posted, the fact table is made up of the first 3 columns under "Data Table" heading.
I want to create time related measures from these three columns (and of course ultimately produce visualizations using the measures over time).
The measures are under the heading "Measures" in the picture.
1. Subsription Count Daily
2. Subsription Count Cumulative or YTD
3. Paid Count Daily
4. Paid Count Cumulative or YTD
5. Paid Ratio Cumulative = Paid Count YTD / Subsription Count YTD
I hope the explanation helps.
I can relate the Subscription Date to the Date Table's Calendar Date and create the first 2 measures Subsription Count Daily and Cumulative (or YTD). What I am having trouble with conceptually is how to get the Paid Count Daily and Cumumlative (or YTD) measures using the same Date Table used by the Subsription Date. The Date Table can only be linked to one date on the Fact Table (=Subsription Date).
Do I need a second Date Table linked to the Paid Date, and then somehow relate the 2 Date Tables so I can compare the Subsription and Paid measures with one common Calendar Date? Or can I use DAX Filters/IF statements?
Thank you again for your consideration of my question.
Mark