Forum Discussion
Helper IReally need some help... Date Table School Terms
BLAWHEEM1 , Make sure you do it in the Separate term table.
Create a Rank on start Date
New column
Term Rank = RANKX(all('Date'),'Date'[Start Date],,ASC,Dense)
measure example
This Term = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Term Rank]=max('Date'[Term Rank])))
Last Term = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Term Rank]=max('Date'[Term Rank])-1))
Super UserBLAWHEEM1 , Make sure you do it in the Separate term table.
Create a Rank on start Date
New column
Term Rank = RANKX(all('Date'),'Date'[Start Date],,ASC,Dense)
measure example
This Term = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Term Rank]=max('Date'[Term Rank])))
Last Term = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Term Rank]=max('Date'[Term Rank])-1))
- BLAWHEEM1
Hi amitchandak
Sorry if being bit dense, new to all this and self taught....
When you say do it in separate term table, are you saying I should have a table per the post which just shows the term dates, ie this one:
Term Order Start Date End Date Autumn 1 03/09/2020 04/01/2021 Spring 2 05/01/2021 18/04/2021 Summer 3 19/04/2021 31/08/2021 Thanks for taking time to reply!
