Suggest an Idea

[ghaliabed]

Create new functions that enable Last Non Empty querying similar to OLAP cubes to better handle semi additive measures.

Ex, If i have data set of Closing Balances at month level, i want to directly have a single master measure that if grouped by Year or Quarter or Period, and by any other Dimension, to directly show the last Date Period value available 

Currenlty the only way to do this is a have a specific set expression per Calendar property ex for Year

        Sum // YEAR LEVEL
        (
            Aggr
            (
                If
                (
                    [Year Month Number] = Max(TOTAL <[Fiscal Year]> [Year Month Number]), 
                    Sum(ClosingAmount)
                ), 
                [Fiscal Year], [Quarter Year], [Year Month Number], FACTTABLE_UNIQUE_KEY
            )
        )

[John_Teichman]

Hello @ghaliabed,

Thank you for your idea. Going forward, please use one and only one label when submitting an idea. We use the labels to route ideas to the appropriate product manager. Things can get "confused" when there are multiple labels. Please refer to the submission guidelines for more details. 

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.