need help to perform 2024 net wt(100%) - 2023 net wt(100%)/2023 net wt(100%) using matric visuals

[deven11]

full image below

[v-xinruzhu-msft · Accepted solution]

Hi,

Thanks for rajendraongole1's concern about the problem, and i want to offer some more information for user to refer to.

hello @deven11  , you can refer to the following solutions

1.Create a calendar table.

Calendar = ADDCOLUMNS(CALENDAR(DATE(2023,1,1),DATE(2024,12,31)),"Year",YEAR([Date]),"Month",MONTH([Date]))

and create a 1:n relationship between tables

2.Create the following measures.

Sum_netwet = SUM(ZIPQ[Net Wt(100%)])

pre_netwt =
IF (
    ISINSCOPE ( 'Calendar'[Month] ),
    CALCULATE (
        [Sum_netwet],
        OFFSET (
            -1,
            ALLSELECTED ( 'Calendar'[Month] ),
            ORDERBY ( 'Calendar'[Month], ASC )
        )
    ),
    CALCULATE (
        CALCULATE (
            [Sum_netwet],
            OFFSET (
                -1,
                ALLSELECTED ( 'Calendar'[Year] ),
                ORDERBY ( 'Calendar'[Year], ASC )
            )
        )
    )
)

_difference = DIVIDE([Sum_netwet]-[pre_netwt],[pre_netwt])

3.Put the following field to the matrix,

Output

Best Regards!

Yolo Zhu

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

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[deven11]

HERE I ATTCHED PBIX FILE AS PER MY REQUIREMENT. PLEASE FIND FILTER ON THAT FILE AND AS PER FILTER OF YEAR AND MONTH I NEED GROWTH %

PLEASE HELP ME

[Ashish_Mathur]

I have already shared my solution with you.

[deven11]

https://www.dropbox.com/scl/fi/5tm26lk90kdu0prg0kqb9/exa-2.pbix?rlkey=78urv58z5frx0bsb7x1uvp1pz&st=b...

[deven11]

here is my pbix link for better understand

https://www.dropbox.com/scl/fi/11wv1ucrqojsfkzm1t2zh/exa.pbix?rlkey=bm46ac61h2r1hbd1mezwtukju&st=04

[v-xinruzhu-msft]

Hi @deven11 

I offered a solution above,  it is the 7th message, and the solution Ashish_Mathur  offered is the 8th message, you can refer them.

Best Regards!

Yolo Zhu

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

[v-xinruzhu-msft · Accepted solution]

Hi,

Thanks for rajendraongole1's concern about the problem, and i want to offer some more information for user to refer to.

hello @deven11  , you can refer to the following solutions

1.Create a calendar table.

Calendar = ADDCOLUMNS(CALENDAR(DATE(2023,1,1),DATE(2024,12,31)),"Year",YEAR([Date]),"Month",MONTH([Date]))

and create a 1:n relationship between tables

2.Create the following measures.

Sum_netwet = SUM(ZIPQ[Net Wt(100%)])

pre_netwt =
IF (
    ISINSCOPE ( 'Calendar'[Month] ),
    CALCULATE (
        [Sum_netwet],
        OFFSET (
            -1,
            ALLSELECTED ( 'Calendar'[Month] ),
            ORDERBY ( 'Calendar'[Month], ASC )
        )
    ),
    CALCULATE (
        CALCULATE (
            [Sum_netwet],
            OFFSET (
                -1,
                ALLSELECTED ( 'Calendar'[Year] ),
                ORDERBY ( 'Calendar'[Year], ASC )
            )
        )
    )
)

_difference = DIVIDE([Sum_netwet]-[pre_netwt],[pre_netwt])

3.Put the following field to the matrix,

Output

Best Regards!

Yolo Zhu

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

[rajendraongole1]

Hi @deven11 - your question is not clear, can you please share in detail what is the current value and what is expected?

also share pbix file by removing the sensitive data it helps.

[deven11]

here is pbix file link to better understand

https://www.dropbox.com/scl/fi/11wv1ucrqojsfkzm1t2zh/exa.pbix?rlkey=bm46ac61h2r1hbd1mezwtukju&st=04

[deven11]

how to share pbix file

[deven11]

want to perform 59342-55647/55647