Forum Discussion
Post PatronPREVIOUMONTH not returning the value
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
Community ChampionHi 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
KatkaSThank 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
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!!