Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Create a new column "Total Variance"

Hello,   I have a table that looks this    Table Name: Project Costs    Columns: ID, ProjectNum, Budget, Variance, POC, Region, Country, SnapshotDate.    My problem is I want to calculate the...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-xjiin-msft,

 

Thanks for your response. I tried to calculate Total Variance and YTD values

Total Variance = (SUM('Project Costs'[Variance])-CALCULATE(SUM('Project Costs'[Variance]), PREVIOUSMONTH('Project Costs'[Snapshot Date].[Date])))*-1

 

YTD (January) = Total variance (January)* POC(January)

 

But I am unable to find out MTD values for the table. 

MTD (January) = YTD (January) - YTD (December), this is the calculation.

 

But how can measure MTD values in Power BI report? Please help me, thanks 

 

Bhavesh

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi Anonymous,

 

Could you please share us your pbix file, or your excel file with detailed sample data and the desired result if possible? Otherwise, it is hard for us to understand your requirement clearly.

 

Thanks,

Xi Jin.