Forum Discussion
Divide SUM values from 2 tables (with date table/reference)
Hi, I have a table which shows SUM values from 2 different tables - I would like to calculate: Delta Date / Tons The data have a Calender table as common reference, How would I calcula...
AlB
Community Champion
Community ChampionHi Anonymous
It would be best to use explicit measures rather than implicit ones. Create a measure:
Measure =
DIVIDE ( SUM ( DataLog[DeltaData] ), SUM ( THA_JWIOVN[Tons] ) )
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