Forum Discussion

Hinnax's avatar
Hinnax
Frequent Visitor
5 years ago
Solved

Time Intelligence over 2 Months

Hello everyone, I’m pretty new to Power Bi so I‘m afraid my question is too trivial for this forum. Before I describe the problem, let me start with my setup: I use a date table with dates ove...
Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    5 years ago

    Hinnax and here is the measure:

     

    Measure_Dec+Jan = 
CALCULATE(
[Measure_1],
FILTER ( 
ALL ( 'Date'[Date] ), 
'Date'[Date] <= MAX ( 'Date'[Date] ) ) 
)

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Hinnax you have provided a lot of great details but it will be easier if you share sample data and expected output. Start from there and you get into more details.

  • Hinnax's avatar
    Hinnax
    Frequent Visitor
    5 years ago

    Just a quick shot:

    The values for January getting summarized fine.
    In the Visual for January + December the two months are summarized seperately. The red arrow in my posts marks the same point in my data. It's the beginning of January. In the Visual for January + December, I expected that the Values from January get summarized with the Values from December, without a "reset".
    The calculations for January are the same in both Visuals.

    I  clearly underestimated how much sample data is needed tho answer my question. Unfortunately I only could provide the original data from my company at this moment. I'll prepare better examples to post them tomorrow.