What function to use for checking the previous inventory

DAX
1

Hello,

I have a simple table with start and end inventory number for a number of subsidories and for months

The final objective is to check if
INVENTORY END OF PERIOD N = INVENTORY START OF PERIOD N+1 for each VB BA subsidory

if yes “OK”
if no " check your input "

N = month

this table is imported in power BI and the check needs to be done in power BI

what is the best approch in power BI to get the jeb done?
using offset() window() or another pattern

see tab CHECK for the wanted result
attached the file that wil be loaded in power BI
check for inventory.xlsx (104.0 KB)

image

thanks in advance

Roger