Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have this measure built out to calculate an account's exposure in the prior quarter:
Solved! Go to Solution.
Hi @Anonymous ,
You will need to add ALL() function when calculating priorqtr.
And if you want previous quarter, you might consider to use "<" instead of "<>".
Measure =
var currentqtr = MAX(Account_Data_Total[Quarter])
var priorqtr = CALCULATE(MAX(Account_Data_Total[Quarter]),FILTER(ALL(Account_Data_Total),Account_Data_Total[Quarter]<currentqtr))
return
priorqtr
Best Regards,
Jay
Thank you so much for the advice, this worked very well!
Hi @Anonymous ,
You will need to add ALL() function when calculating priorqtr.
And if you want previous quarter, you might consider to use "<" instead of "<>".
Measure =
var currentqtr = MAX(Account_Data_Total[Quarter])
var priorqtr = CALCULATE(MAX(Account_Data_Total[Quarter]),FILTER(ALL(Account_Data_Total),Account_Data_Total[Quarter]<currentqtr))
return
priorqtr
Best Regards,
Jay
@Anonymous , Not very clear. First of use time intelligence for this
example
QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))
Also for what you have in this period , what you had in last period
follow the same approach using QTD and account and bucket
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |