Added Row : adjust added row formula based on Column Header

YbrEsko commented 7 months ago

Hi,

Is below possible ? I have 3 measures in the BI (Year / Year-1/Variance) I added a row with formula to calculate Gross Profit 1% for measure "Year"/"Year-1" this is OK but for the "Variance" I want to calculate this as Year minus Year-1 (see included file)

the product columns are not fixed - so they depend on specific selections.
I tried following

add column formula at level of "Variance Year - Year-1" seems not possible
add column formula in column of prod 1 ( in combination with RowHeader() =="Gross Profit 1 %) and selected "year prod 1" - year-1 prod1" but then formula of prod 1 is applied to all products (on all columns of "Variance Year - Year-1"

Any suggestions - thanks for your feedback

ProfitBaseQuestion.docx

AndersAano commented 7 months ago

Hi @YbrEsko,

Thanks for bringing this to our attention. I'm able to recreate your issue, but currently not able to make it work.

We'll take a look and see if we can make a fix for this, because it should be possible to do it the way you are trying to do it.

best regards Anders

YbrEsko commented 7 months ago

Thanks Anders for the quick reply and hopefully soon good news.

Best regards, Yannick

Confidential - Company Proprietary

From: Anders Aano @.> Sent: Thursday, April 11, 2024 9:29 AM To: Profitbase/PowerBI-visuals-FinancialReportingMatrix @.> Cc: Broucke, Yannick @.>; Mention @.> Subject: Re: [Profitbase/PowerBI-visuals-FinancialReportingMatrix] Added Row : adjust added row formula based on Column Header (Issue #595)

Hi @YbrEsko, Thanks for bringing this to our attention. I'm able to recreate your issue, but currently not able to make it work. We'll take a look and see if we can make a fix for this, because it should be possible to do it the way you are

Hi @YbrEskohttps://urldefense.com/v3/__https:/github.com/YbrEsko__;!!AC-Zr9Eh!LaVvMXbFRgaedd-2bBVzJaoAgIUcy0-DJm5_AJ0yo-_oTju326w-aTd1Vz_qQFrKRFDgaaj6gvjyTo3GkVgUuPNYvxhK$,

Thanks for bringing this to our attention. I'm able to recreate your issue, but currently not able to make it work.

We'll take a look and see if we can make a fix for this, because it should be possible to do it the way you are trying to do it.

best regards Anders

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/issues/595*issuecomment-2049091621__;Iw!!AC-Zr9Eh!LaVvMXbFRgaedd-2bBVzJaoAgIUcy0-DJm5_AJ0yo-_oTju326w-aTd1Vz_qQFrKRFDgaaj6gvjyTo3GkVgUuDvrhB6b$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/BHXCG5U6QEGUUWV2ZU5LDBTY4Y3TFAVCNFSM6AAAAABGACBUZ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANBZGA4TCNRSGE__;!!AC-Zr9Eh!LaVvMXbFRgaedd-2bBVzJaoAgIUcy0-DJm5_AJ0yo-_oTju326w-aTd1Vz_qQFrKRFDgaaj6gvjyTo3GkVgUuEhZkbbk$. You are receiving this because you were mentioned.Message ID: @.**@.>>

Please be advised that this email may contain confidential information. If you are not the intended recipient, please notify us by email by replying to the sender and delete this message. The sender disclaims that the content of this email constitutes an offer to enter into, or the acceptance of, any agreement; provided that the foregoing does not invalidate the binding effect of any digital or other electronic reproduction of a manual signature that is included in any attachment. [0xC3D2]

YbrEsko commented 5 months ago

Hi Anders,

Just a friendly follow-up.

Any idea if this would be feasible ?

Thanks for your feedback, Best regards, Yannick

Confidential - Company Proprietary

From: Anders Aano @.> Sent: Thursday, April 11, 2024 9:29 AM To: Profitbase/PowerBI-visuals-FinancialReportingMatrix @.> Cc: Broucke, Yannick @.>; Mention @.> Subject: Re: [Profitbase/PowerBI-visuals-FinancialReportingMatrix] Added Row : adjust added row formula based on Column Header (Issue #595)

Hi @YbrEsko, Thanks for bringing this to our attention. I'm able to recreate your issue, but currently not able to make it work. We'll take a look and see if we can make a fix for this, because it should be possible to do it the way you are

Hi @YbrEskohttps://urldefense.com/v3/__https:/github.com/YbrEsko__;!!AC-Zr9Eh!LaVvMXbFRgaedd-2bBVzJaoAgIUcy0-DJm5_AJ0yo-_oTju326w-aTd1Vz_qQFrKRFDgaaj6gvjyTo3GkVgUuPNYvxhK$,

Thanks for bringing this to our attention. I'm able to recreate your issue, but currently not able to make it work.

We'll take a look and see if we can make a fix for this, because it should be possible to do it the way you are trying to do it.

best regards Anders

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/issues/595*issuecomment-2049091621__;Iw!!AC-Zr9Eh!LaVvMXbFRgaedd-2bBVzJaoAgIUcy0-DJm5_AJ0yo-_oTju326w-aTd1Vz_qQFrKRFDgaaj6gvjyTo3GkVgUuDvrhB6b$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/BHXCG5U6QEGUUWV2ZU5LDBTY4Y3TFAVCNFSM6AAAAABGACBUZ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANBZGA4TCNRSGE__;!!AC-Zr9Eh!LaVvMXbFRgaedd-2bBVzJaoAgIUcy0-DJm5_AJ0yo-_oTju326w-aTd1Vz_qQFrKRFDgaaj6gvjyTo3GkVgUuEhZkbbk$. You are receiving this because you were mentioned.Message ID: @.**@.>>

Please be advised that this email may contain confidential information. If you are not the intended recipient, please notify us by email by replying to the sender and delete this message. The sender disclaims that the content of this email constitutes an offer to enter into, or the acceptance of, any agreement; provided that the foregoing does not invalidate the binding effect of any digital or other electronic reproduction of a manual signature that is included in any attachment. [0xC3D2]

Profitbase / PowerBI-visuals-FinancialReportingMatrix

Added Row : adjust added row formula based on Column Header #595