Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have Pivot table . I made dimension in rows and i see exact value that I need (number 1).
=aggr({distinct}[Period (Discount)],[Business Unit],[Country (Discount)])
Then I'm trying to add this value to [BILL AMT] measure calculation to sum amount with dates filtered by from and to using addmonths function like:
=Sum( {$<[Creation date (billing)]= {">=$(=addmonths (vDateEnd,-aggr({distinct}[Period (Discount)],[Business Unit],[Country (Discount)]) ))<=$(=Date(vDateEnd))"}>} [BILL AMT] )
I want the "aggr()" part to be changed to 1. But it not happening... Chart ignores the statement and returns values like =SUM([BILL AMT])
If I manually replace the "aggr()" with 1 I will get what I want, but this value should be dynamic (base on loaded data)...
=Sum( {$<[Creation date (billing)]= {">=$(=addmonths (vDateEnd,-1 ))<=$(=Date(vDateEnd))"}>} [BILL AMT] )
I've already spent many days finding what exactly i can do and now I'm facing this issue.
Thank you in advance!
Yury.
Can you attach sample demo with app. Have you create a calendar in your model ?
Vikas