Forum Discussion
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...
if anyone can help to come up with a solution that would be great!
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
Hi unfortunately that just loops and doesnt provide a calulation.
HI Anonymous,
I'd like some sample data for test.
Regards,
Xiaoxin Sheng
Hi Anonymous
for example
YEAR_ENDING PERIOD POSTING_DATE NAV_NO_CODE NAV_NO_DESCRIPTION Customer Number Customer DOCUMENT_NO QUANTITY Revenue CUSTOMER_NAME MANUFACTURER Revenue Group Hierarchy Level 3 2018 1 01/01/2018 NX-11111 Heinz ACC155 INVOICE123 1 20 Newci Heinze CONDIMENTS TEA 2018 1 01/03/2018 KTCH1 Ketch ACC155 INVOICE125 1 15 DALE Heinze CONDIMENTS LUNCH 2018 1 01/01/2018 SLDCRM1 SALAD ACC156 INVOICE126 6 200 BOROM WORCESTER CONDIMENTS LUNCH