PREVIOUMONTH not returning the value

[KatkaS]

Hello,

I have a simple excel sheet and would like to display value of previous month.

I tried to create new calculated colum and new mesure but none of them is returning any value...

COuld someone please help?

Thank you!!

[camargos88]

Hi @KatkaS ,

It will work if you have a continous date table.

Check these links:

https://docs.microsoft.com/pt-br/dax/previousmonth-function-dax

https://docs.microsoft.com/en-us/dax/time-intelligence-functions-dax

Ricardo

[KatkaS]

Thank you, Ricardo.

Do you mean in the table itself..? Or in a separate table and then make a relationship between two excels?

Thank you..

[camargos88 · Accepted solution]

@KatkaS ,

Yes, you need a separated table and relate it to your table.

You can use the function CALENDAR to get the min/max dates from your table and create it.

If you consider it as a solution, please mark as a solution and kudos.

Ricardo

[KatkaS]

Thank you, Ricardo!!