Hi All,
I have an issue with the measures in table 1 that I have selected in a DAX table, where on certain records they are calculating marginally different values. See below table structure:
Table 1:
| | Row ID | Value 1 | Start Month | Month 1 Value | Month 2 Value | Month 1 Measure A | Month 2 Measure A | Month 1 Measure B | Month 2 Measure B | Month 1 Measure C | Month 2 Measure C |
| Formula | ID | Input | Input | Input | Input | (Month 1 Value/Value 1)*(Table 2 Measure) | (Month 2 Value/Value 2)*(Table 2 Measure) | Month 1 Value - Month 1 Measure A | Month 2 Value - Month 2 Measure A | EDATE(startmonth,0) | EDATE(startmonth,1) |
Table 2:
| Table 2 Measure |
| Sum of values from related tables |
I have created a dax table as below:
DAX =
UNION(
SELECTCOLUMNS('Table1',"Type","Revenue","ID",[Row ID],"Start Month",
[Start Month],"Month 1",[Month 1 Value],"Month 2",[Month 2 Value]),
SELECTCOLUMNS('Table1',"Type","Forecast cost","ID",[Row ID],"Start Month",[Start
Month],"Month 1",[Month 1 Measure A],"Month 2",[Month 2 Measure A]),
SELECTCOLUMNS('Table1',"Type","Net","ID",[Row ID],"Start Month",[Start
Month],"Month 1",[Month 1 Measure B],"Month 2",[Month 2 Measure B]),
SELECTCOLUMNS('Table1',"Type","Month","ID",[Row ID],"Start Month",[Start
Month],"Month 1",[Month 1 Measure C],"Month 2",[Month 2 Measure C])
)
The DAX table splits the single row into 4, so that I can stack the values in a matrix by month.
When I put the values from the source tables onto the report, all the calculations are correct.
The issue is with Measure A in the DAX table - sometimes it returns the correct values, and sometimes it is out by anywhere from 0.07%-10%.
Can anyone suggest what I'm doing wrong?
Thankyou in advance!
