Forum Discussion
Sales Data analisys
I need to create a Dashboard that shows the status of the clients: Recurring, Inactive for 6 months, or Inactive for 12 months. The problem is, I have tho analyse the sales monthly, so I can map i...
- LastsalePreviousMonth = CALCULATE( MAX( Base[Dt Entrega]),ALLEXCEPT('Calendar,'Calendar'[Start of the month]), PREVIOUSMONTH("Your Calendar Table Here"))
LuizKoller
Resolver I
Resolver IThe last sale of the month is a collumn or a measure?
You can try the PREVIOUSMONTH function:
Depends on the structure of your data
The last sale of the month is a measure
Lastsale = CALCULATE( MAX( Base[Dt Entrega]),ALLEXCEPT('Calendar,'Calendar'[Start of the month]))
- LuizKollerLastsalePreviousMonth = CALCULATE( MAX( Base[Dt Entrega]),ALLEXCEPT('Calendar,'Calendar'[Start of the month]), PREVIOUSMONTH("Your Calendar Table Here"))