Forum Discussion

niculeica's avatar
niculeica
Helper I
2 years ago
Solved

Calculate Measure1 as Measure2 + Measure3 Running Total

Hi,   I'm trying to calculate Measure1 (Total Value) as Measure2 (Signed Contracts) + all backlog of Measure3 (Pending Contracts), everything displayed by date hierarchy (Year, Quarter, Month). So ...
Need Help
  • speedramps's avatar
    speedramps
    2 years ago

    Click here to download the solution

    Download PBIX 

     

    How it works ...
    Create a Calandar table

     

    Create a measure

    YTD cumulative = 
VAR myyear = SELECTEDVALUE('Calendar'[Year])
VAR myperiod = MAX('Calendar'[Date])
RETURN
CALCULATE(
    SUM(Facts[Amount in company currency]),
    ALL('Calendar'),
    'Calendar'[Year] = myyear &&
    'Calendar'[Date] <= myperiod 
)

     

    Dsiplay in matrix

     

    Thanks for the clear description of the problem with example data. I wish everyone did that!

    Remember we are unpaid volunteers. So please click the thumbs up and the [accept as solution] button to leave kudos. 

    One question per ticket please. If you need to extend your request then please raise a new ticket.

    You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

    If you quote speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

    Please now click the thumbs up and the [accept as solution] button.  Thnak you.

speedramps's avatar
speedramps
Super User
2 years ago

We want to help you but your description is too vaugue. Please write it again clearly

Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.
Also provide the example desired output, with a clear description of the process flow.

Remember not to share private data ... we don't want you to get into trouble. 😧

Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.

You will get a quick response if you put time, care and effort into writing clear problem descriptions.

Vaugue descriptions can waste your time and ourtime.

Look foward to helping you when the above information is forthcoming