Forum Discussion
Solved
Calculated Field Between Two tabales
I have 2 tables which have the same column headings. One is a snapshot of data taken at the start of the month and one is a snapshot taken at the start of every week. I am looking to have a calcu...
Don't think a merge is a good idea here, would create a TON of unnecessary data.
I'd recommend making that as a measure (don't know what table to house it in, doesn't matter much):
Difference = SUM('Curr Month Snap FY'[Start of Month Revenue]) - SUM('Curr Week Snap FY'[Start of Week Revenue])
Don't think a merge is a good idea here, would create a TON of unnecessary data.
I'd recommend making that as a measure (don't know what table to house it in, doesn't matter much):
Difference = SUM('Curr Month Snap FY'[Start of Month Revenue]) - SUM('Curr Week Snap FY'[Start of Week Revenue])
point taken
