Need to show % Value of last closed period (Pervious Month) in Card/Score Card Visual

[prasad_08mm]

Hello All,

I Need to show % Value of last closed period (Pervious Month) in Card/Score Card Visual

For example - If I run the report for Postin Period - 003/March the score card should show PP - 002/feb i.e. 100% , like wise  if run the report for PP - 002/Feb the scroe card should show PP-001/Jan i.e. 75.45% 

Please guide 

[v-zhangti · Accepted solution]

Hi, @prasad_08mm 

You can try the following methods.
Create a new column:

FYPP = [FY]&[PP]

Measure:

Pervious Month = 
Var _select=SELECTEDVALUE('Table'[FYPP])
Var _Pre=CALCULATE(MAX('Table'[FYPP]),FILTER(ALL('Table'),[FYPP]<_select))
Return
CALCULATE([% Value],FILTER(ALL('Table'),[FYPP]=_Pre))

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[prasad_08mm]

I tried with the below  DAX  but it is showing blank

last_month_sales =

    var current_month= MONTH(TODAY())

        return  

            CALCULATE(

                        [FA W6],

                        FILTER('********) - Test',MONTH('***** - Test'[Posting period.Posting period Level 01])=current_month ))

[prasad_08mm]

please reply community