Label in Pivot table

[upaliwije]

Hi Friends

I have shown here a screenshot of my pivot table where date in label  of last column is incorrectly shown as 31-Feb-2020 and it should actually be 28-feb 2020.

My expression for label is   ='Balance as at '&Day(MonthEnd(Date#(PERIODID,'D')))&'-'&Date(Date#(PERIOD,'YYYYMM'),'MMM-YYYY')

Kindly help me to get it corrected.

[sergio0592 · Accepted solution]

Hi,

Try with

Date(monthend(Date#('01'&PERIOD,'DDYYYYMM')),'DD-MMM-YYYY')

[upaliwije]

Thanks It works,

But I want to what does it mean by  

'01'

in your expression. Pls clarify for me to learn 

[sergio0592]

It's just for represent in the date the first day of month. It's the DD in DDYYYYMM.

[upaliwije]

Thanks