Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Need help filtering dates with a Period slicer !

Hi all, i am trying to calculate a last period revenue figure, i.e sum the value of the sales of accounts b   H1[Final Amount] is the revenue (calculation) H1[ posting date] are the order dates L...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

if anyone can help to come up with a solution that would be great!

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    Maybe you can try to use below measure if it works for your requirement:

    Last Period Revenue =
VAR currentDate =
    MAX ( H1[Posting Date] )
RETURN
    CALCULATE (
        SUM ( H1[Final Amount (£)] ),
        FILTER (
            ALLSELECTED ( H1 ),
            Hi[Posting Date]
                >= currentDate - MIN ( [Select Period], 0 )
                && Hi[Posting Date] <= LASTDATE ( VALUES ( H1[last invoice date] ) )
        )
    )

    If not help, please share sample or pbix file with expected results.

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous

      Hi unfortunately that just loops and doesnt provide a calulation.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI Anonymous,

         

        I'd like some sample data for test.

         

        Regards,

        Xiaoxin Sheng