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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
b3nkumar
New Member

Need urgent help on creating a report

Can anyone please help how I can reach to the output:-


Please refer data and output detail as below:-

 Data       
  Balance1Balance2Metrics1Metrics2   
Friday4/14/2023100020001020   
Monday4/17/20231001200011121   
Tuesday4/18/20231002200021222   
Wednesday4/19/20231003200031323   
Thursday4/20/20231004200041424   
Friday4/21/20231005200051525   
Monday4/24/20231008200081828   
Tuesday4/25/20231009200091929   
Wednesday4/26/20231010200102030   
Thursday4/27/20231011200112131   
Friday4/28/20231012200122232   
         
         
 Output       
         
  Balance1 DeltaBalance2 DeltaMetrics1 deltaMetrics2 delta   
 4/28/20231012200122232   
 4/27/20231011200112131   
 current vs Prior11NA1   
 vs BaseNANA67   
         
 6 is resultant of delta from a static table value      
 7 is resultant of delta from a statis table value      
 NA is columns where delta are not required      
 only latest 2 dates data should be populated and delta between these but only for Weekdays/Non Holiday data   
1 REPLY 1
v-rzhou-msft
Community Support
Community Support

Hi @b3nkumar ,

 

The output you want looks like a matrix visual. However, I think latest 2 dates should come from [Date] column. So [Current vs Prior] and [vs Base] should be separate measures. I think they couldn be show in same field with your current data model.

If you want to calculate latest two days without weekends/holidays, you can create a calendar table with continuous dates and determind the days in it.

For reference:

Use DAX to create a calendar table with holidays - Microsoft Power BI Community

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.