Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |