Showing data from current month as well as a month prior in gallery labels

[mqcp]

So I have a table with data entries for tracking product amounts month to month. One of my columns, "Month Entered", tracks when a product was added to the data table. Within my power app I have a gallery with labels as follows: Product Name, Last Month, This Month. With Last Month and This Month being the count for the month. My question is, is there some way to obtain the date of Last Month by subtracting from This Month. (i.e. This Month = February;  This Month - 1 Month = January).

[WarrenBelz · Accepted solution]

Hi @mqcp ,

You should just need

Month(ThisItem.'This Month') - Month(ThisItem.'Last Month')

but allowing for December/January and previous years

Month(ThisItem.'This Month') - Month(ThisItem.'Last Month') + 
If(
   Year('Last Month') < Year(Today()),
   12 * (Year(Today()) - Year('Last Month'))
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[WarrenBelz]

Hi @mqcp ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps