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.
apptime adj = if [academic year]="2016-2017" then Date.AddDays([apptime],1095) else if [academic year]="2017-2018" then Date.AddDays([apptime],730) else if [academic year]="2018-2019" then Date.AddDays([apptime],365) else [apptime]
Newest Date = MAX(application_count[apptime])
Then, filter application counts before the current time from previous years:
Total Apps Adj = if(application_count[apptime adj]<application_count[Newest Date],application_count[Total Apps],BLANK())
This returns the desired result, but the totals are off. Thanks in advance for you help.
You may use ISINSCOPE to add a measure.
Measure 2 =
IF (
ISINSCOPE ( 'Dates Adj'[Month Year] ),
SUM ( application_count[Total Apps Adj] ),
SUM ( application_count[Total Apps] )
)
@v-chuncz-msft thanks for your help. I applied your solution, but it did not change anything.
Could you show me the solution in the actual .pbix file?
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |