Calculate Days from Duration

[ckw_ivo]

Hi, hope there is some help out there.

My data are periods of time.

¦DateFrom ¦ DateTo ¦ MembershipProduct ¦ Customer¦

¦2019-1-1 ¦ 2019-03-31 ¦ A ¦ 1¦

¦2019-4-1 ¦ 2099-12-31 ¦ B ¦ 1¦

¦2019-3-1 ¦ 2099-12-31 ¦ B ¦ 2¦

I need to visualize

1. change of the products over time

2. compare to report dates to each other (f.e. compare MembershipProducts at dates 2019-02-15 and 2019-05-12)

¦MembershipProduct¦CountForDate1¦CountForDate2¦

¦A¦1¦0¦

¦B¦0¦2¦

3. determine upgrades and downgrades within a periode (or the two dates above 2019-02-15 and 2019-05-12)

¦Customer¦UpDownGrade¦

¦1¦Upgrade (A-->B)¦

¦2¦NewCustomer (B)¦

Any idea to achieve those reports?

Thank you for your help!

[v-diye-msft · Accepted solution]

Hi @ckw_ivo ,

Let me know if you'd like to ge the result like this:

pbix attached here: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EW6lQYoIla9Jh1hH1QkZ7f...

[ckw_ivo]

Great, that's it!

Is there a possibility to use a single date picker für date1 and date2?

Best regards,

Ivo

[v-diye-msft]

Hi @ckw_ivo ,

I don't think it's possible to set them in one slicer, coz the condition would become : filter the results which meet both Dates1&&Dates2, and it's not your meaning i figure.

Best regards,

Dina Ye