Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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...
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...
Great, that's it!
Is there a possibility to use a single date picker für date1 and date2?
Best regards,
Ivo
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |