I am trying to calculate the number of rows that have either Units or Stock greater than zero in the last 2 months.
Units and Stock are in my fact table.
Fact table has the following columns Date, ProdID, StoreID, Units, Stock
I also have a calendar table.
The result I am looking for is the number of rows in the fact table that has either Units OR Stock in the last 2 Months.
My fact table is rather larger so I cant add a calculated column.
Go to Solution.
You may refer to the following measure.
VAR y =
YEAR ( TODAY () )
VAR m =
MONTH ( TODAY () )
>= DATE ( y, m - 1, 1 )
&& ( 'Fact'[Units] > 0
|| 'Fact'[Stock] > 0 )
View solution in original post
Awesome - thank you @v-chuncz-msft || is Just want I needed.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.