rajcognos_03. Calculated measure in matrix. Multiple Columns in Matrix

[rajcognos_03]

Hi

Can somebody help me to get "Delta Measure" (Apr1st - Mar 1st) as shown below in power bi matrix.

Country	Jan 1st	Feb 1st	Mar 1st	Apr 1st	Delta
India	102,541.00	549,681.00	468,645.00	4,574,545.00	4,105,900.00
Italy	5,412,548.00	4,654,621.00	465,421,354.00	794,612.00	(464,626,742.00)
Spain	8,547,512.00	6,841,221.00	564,874.00	56,462,132.00	55,897,258.00
USA	458,954.00	468,764.00	7,845,454.00	897,641.00	(6,947,813.00)

[Anonymous]

Hi @rajcognos_03 ,

Hope you are looking for the formula as below.

Measure = SELECTEDVALUE('Table'[Apr 1st])-SELECTEDVALUE('Table'[Mar 1st])

If not then ee need more information like: 

Is this table a visual or a data table?

Are these columns measures or fact column?

Delta only calculate the Apr1st - Mar 1st or calculate this month minus last month?

Please share your PBIX to me if you don't have any Confidential Information.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajcognos_03]

Hi Jay,

I appriciate for your prompt responce. I don't see an option to attache power bi file here. I think your screenshot has what I need. I request you to send file which you tried earlier or let me know the way to share file to you. Thank you.

Regards,

Raj.

[Anonymous]

Hi @rajcognos_03 ,

Sorry for the delay.

Here's my pbix as attachments.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajcognos_03]

No worries. Thank you so much Jay for file...

If I get following month (May 1st) data, I need to add it manually, I believe. Do we have automated way to get?

Regards,

Raj

[Anonymous · Accepted solution]

Hi @rajcognos_03 ,

Are these "Month" columns or rows? If they are columns i think you have to add it manually. If they are rows in a same column and you have a date column along with it, it might be done.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

?