Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate SUM between two datetimes

Hello Everybody!   I need your input on an approach of mine. I have following table via direct query from a SQL database: The table is conneced to a simple date table, lowest granularity is...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    USERELATIONSHIP did the trick, I had to do some minor changes to my data model and it works now.

    Thanks a lot for the right prompt.

    My solution looks like this:

     

    FM SYS1 6-6 =
    CALCULATE(CALCULATE(SUMX('FM geliefert','FM geliefert'[Nettowert]),
    FILTER('FM geliefert',
    'FM geliefert'[KZ2]="A" ||
    'FM geliefert'[KZ2]="B" ||
    'FM geliefert'[KZ2]="C")),
    USERELATIONSHIP('01 Kalender'[Datum],'05 Schichtzeit Kalendar'[Datum Shift]))
     
    Cheers Rainy

     

AlB's avatar
AlB
Community Champion
5 years ago

Anonymous

Ok, with the realtionship you have between Zeitstempel start  and Zeitstempel it should work. 

Place Datum Schiechbasierte Berechnung in the x-axis of a chart for instance and then a measure like

           Measure = SUM( Table1[Nettowert]) )

should give you the sum between 6-6 for each date

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    That works but is unfortunately not what I need to do.

    I need to use this measure for other calculations with data from different fact table which are connected to my main date table. Also in this scenario I can´t use my main date table as a slicer.

     

    Cheers

    Rainy