Forum Discussion
Calculate Variance in the same Column
You could probably accomplish this but it would probably be a bit of a pain. Basically, use VAR to create temp tables, one with your table as is and another where you create your variance row. Then you UNION them together and this is the RETURN for a calculated New Table. Too late to get more in-depth but the tricky part will be creating that single row table from scratch, that's always a pain.
I'm pretty sure you cannot add rows using DAX. The closest that you can get to the solution that you want is to create a new table with the dates in one column and the difference in another column. Then you can create a relationship between the two table using the dates columns.
You could probably accomplish this but it would probably be a bit of a pain. Basically, use VAR to create temp tables, one with your table as is and another where you create your variance row. Then you UNION them together and this is the RETURN for a calculated New Table. Too late to get more in-depth but the tricky part will be creating that single row table from scratch, that's always a pain.