Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ckw_ivo
New Member

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!

 

1 ACCEPTED SOLUTION
v-diye-msft
Community Support
Community Support

Hi @ckw_ivo ,

 

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

004.PNG

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

3 REPLIES 3
v-diye-msft
Community Support
Community Support

Hi @ckw_ivo ,

 

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

004.PNG

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.