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
novicenovice
Helper I
Helper I

Sum of the last value regarding a relative date (dynamic) and for a specific period

Dear All,

 

I would like to follow the forecast update by getting the sum of the last value for each day

 

in the table below if I select (on my chart) the date of

 

  1. 3rd of January I must have the sum value for

 

  • January = A(6)  + B(5) =11
  • February = Null =0

 

  1. 8th of January I must have the sum value for

 

  • January = A(6)  + B(5) =11
  • February = A(8) + B(9) =17

 

CUSTOMERDATE UPDATEPERIODVALUE
A01/01/20182018.014
B02/01/20182018.015
A03/01/20182018.016
C04/01/20182018.037
A05/01/20182018.028
B06/01/20182018.029

 

Thanks for your help

 

Novice

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@novicenovice,

 

You may add the following measure.

Measure =
SUMX (
    SUMMARIZE ( Table1, Table1[CUSTOMER] ),
    CALCULATE (
        SUMX ( TOPN ( 1, Table1, Table1[DATE UPDATE], DESC ), Table1[VALUE] )
    )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello Sam,

 

Thanks, I tried but doesn't work, 

 

Novice

 

 

 

The graph should show me the last value udpate for a relative date in this case around 13-14K

 

Capture.PNG

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.