Inception to Date financials

Hi Ashish_Mathur ,

Thank you so much, the values match correctly.

I just had another follow-up question on the report layout. Other than, Debit and Debit_Sub, I have other measures as well as part of my report, but those are not stored Inception to Date, so they match correctly when Power BI sums up by default.

I had used Unpivot operation while building my dataset as earlier the measures were separate columns. 

Example - Debit, Debit_Sub, Measure 1, Measure 2 etc, were all separate columns in the table visualization. Due to the unpivoting, we see the column as Type and Amount with their details.

Since we have specifically used a separate calculation measure for Debit and Debit_Sub, how can we represent it under Type and Amount in the table visualization.

Should I rever the Unpivot back to the way it was done originally i.e. continue to have the measures shown as separate columns in the table visualization? Is there an alternate way to represent the data in the unpivoted form currently.

Thanks,

Vishy