CLUSTERED STACKED COLUMN CHART + Display the last month of data

[Alde]

Hi Everyone,

I attached the PBI sample file and attached an image for my idea which I reached to shape staged already.

However, I'd like to use the data from 'Col-Type'[CurrentMonth] instead of typing "Mar" as in the provided sample dax because there're a couple dozens of similar measures will be used for different charts, I cannot really manullay update each and every one of them every month, instead It's my desire to just change data in 'Col-Type'[CurrentMonth].

Or Alternatives for my idea are very much appreciated.

Please help, thank youuuuu <33

https://drive.google.com/file/d/128YEVdMEsiBYfMy-R6J4SowibiA-sXoC/view?usp=sharing

OBActual_OB = 
SUMX('Col_Type',
VAR CurrentType = 'Col_Type'[Col_Type]
    Return
            if
            (CurrentType="OB Actual",
            IF  
            (ISFILTERED('ORDER_TABLE'[MONTH])=False(),
            CALCULATE(Sum('obcb'[OB Actual]), 'obcb'[Month] = "mar"),
            FIRSTNONBLANK('obcb'[OB Actual],1)
            )
            )
        )

[Alde · Accepted solution]

Yayy, I got the SOLUTION

It didn't work because I put the CurrentMonth column in the same table of the month used to check against, now i created another table without making any relationship and use it in the conditional query. 

OBActual_OB = 
SUMX('Col_Type',
            if
            ('Col_Type'[Col_Type]="OB Actual",
            IF  
            (ISFILTERED('ORDER_TABLE'[MONTH])=True(),FIRSTNONBLANK('obcb'[OB Actual],1),
            CALCULATE(Sum('obcb'[OB Actual]),'obcb'[Month]= SELECTEDVALUE(lastdatamonth[LastMonth]))
            )
        ))