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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

delta result from date based data drops via matrix table

Hi,

 

I have a fairly complex data system in which I need to report 3D design data (count, length, area and volume) on a weekly basis.

 

I want to get the delta of change. The images show what I'm working with.  I want to get delta of change for the values via the two most current dates 12/02/20 & 21/02/20. The other option is to have the data selected via a drop down box for "previous" and "current" with the delta. My key point is that I need to get the delta of the data drops.

 

Annotation 2020-04-23 170818.jpg

 

Annotation 2020-04-23 172331.jpg

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I resolved this by using quick measures and coding the date drop data sets

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

I resolved this by using quick measures and coding the date drop data sets

Anonymous
Not applicable

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

All I can tell you right now is that you should check the visuals by ZebraBI. They do deltas automatically.

Best
D
Anonymous
Not applicable

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.