cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

ND Number of rows with Units OR SOH greater than 0

Hi there,

 

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: ND Number of rows with Units OR SOH greater than 0

@MarkCBB,

 

You may refer to the following measure.

Measure =
VAR y =
    YEAR ( TODAY () )
VAR m =
    MONTH ( TODAY () )
RETURN
    COUNTROWS (
        FILTER (
            'Fact',
            'Fact'[Date]
                >= DATE ( y, m - 1, 1 )
                && ( 'Fact'[Units] > 0
                || 'Fact'[Stock] > 0 )
        )
    )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: ND Number of rows with Units OR SOH greater than 0

@MarkCBB,

 

You may refer to the following measure.

Measure =
VAR y =
    YEAR ( TODAY () )
VAR m =
    MONTH ( TODAY () )
RETURN
    COUNTROWS (
        FILTER (
            'Fact',
            'Fact'[Date]
                >= DATE ( y, m - 1, 1 )
                && ( 'Fact'[Units] > 0
                || 'Fact'[Stock] > 0 )
        )
    )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helper V
Helper V

Re: ND Number of rows with Units OR SOH greater than 0

Awesome - thank you @v-chuncz-msft || is Just want I needed.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors