Forum Discussion

New Member

7 years ago

Solved

Calculate Days from Duration

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
7 years ago
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/EW6lQYoIla9Jh1hH1QkZ7fABkew4XB_n4Yuwy0Qe3gfv4w?e=E3hhr3

3 Replies

v-diye-msft
Community Support
7 years ago
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/EW6lQYoIla9Jh1hH1QkZ7fABkew4XB_n4Yuwy0Qe3gfv4w?e=E3hhr3
- ckw_ivo
  New Member
  7 years ago
  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
    Community Support
    7 years ago
    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