Dynamic Measure Required with two slicer

[mohitchugh]

Hi Folks,

I'm trying to develop the dashboard by comparing two months and their uses of two slicers.

I prepared the dashboard using Excel Formulas. please help to develop Power-BI

As the Raw data is attached Excel is available. please refer it

Google Drive Link for Excel File 

Please feel free to contact for more info if required.

RAW Data

Period	Account	Value X	Value Y	Value Z
Fix	Tata	4	3	5
Fix	Birla	6	7	8
Fix	Adani	7	8	9
Fix	RIL	8	9	10
Fix	Tata	9	10	11
Fix	Birla	10	11	12
Jan	Adani	11	12	13
Jan	RIL	12	13	14
Jan	Tata	13	14	15
Jan	Birla	14	15	16
Jan	Adani	15	16	17
Feb	RIL	16	17	18
Feb	Tata	17	18	19
Feb	Birla	18	19	20
Feb	Adani	19	20	21
Feb	RIL	20	21	22
March	Tata	21	22	23
March	Birla	22	23	24
March	Adani	23	24	25
March	RIL	24	25	26
March	Tata	25	26	27
March	Birla	26	27	28
March	Adani	27	28	29
April	RIL	28	29	30
April	Tata	29	30	31
April	Birla	30	31	32
April	Adani	31	32	33
April	RIL	32	33	34
April	Tata	33	34	35

Regards,

MOHIT

[Jihwan_Kim · Accepted solution]

Hi, I could not access to the googledrive, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

Fix: = 
CALCULATE (
    SUM ( Data[Value] ),
    REMOVEFILTERS ( Period ),
    Period[Period Number] = 0
)

Selected period: = 
SUM( Data[Value])

OFFSET function (DAX) - DAX | Microsoft Learn

Previous period: = 
VAR _previousperiodnumber =
    MAX ( Period[Period Number] ) - 1
VAR _condition = _previousperiodnumber <> 0
RETURN
    IF (
        _condition,
        CALCULATE (
            SUM ( Data[Value] ),
            OFFSET (
                -1,
                ALL ( Period[Period Number], Period[Period] ),
                ORDERBY ( Period[Period Number], ASC )
            )
        )
    )

Selected period fix: = 
[Selected period:] - [Fix:]

Diff: = 
[Selected period:] - [Previous period:]

[mohitchugh]

Thanks for quick solutions...

It's work