Simple problem driving me crazy - help!

Anything related to PowerPivot and DAX Formuale
Tantalus86
Posts: 1
Joined: Sun Apr 14, 2019 7:40 pm

Simple problem driving me crazy - help!

Postby Tantalus86 » Sun Apr 14, 2019 11:15 pm


PhilC
Posts: 274
Joined: Tue Sep 09, 2014 8:13 am

Re: Simple problem driving me crazy - help!

Postby PhilC » Thu Apr 18, 2019 8:37 pm

Hi Tantalus86,

Have you tried your measure with ALL instead of ALLSELECTED? You want to capture all transactions that have ever occurred prior to the last date of the slicer. ALLSELECTED will only include transactions that occur between the start and end dates of the slicer, so you need to use ALL to access all dates. The 'Date'[Date] <= MAX ('Date'[Date] should then limit it to the MAX date of the slicer time period (I think).

The measure you have shown would not be the balance though, as you are not bringing in the initial balance. Maybe create a measure for that as well, then the balance would be addition of the two measures.

Post a workbook if the above does not work, as that will provide something for us to play and test with.

Cheers
Phil


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests