Forum Discussion
Time slice in DAX
Hi All,
Need help in deriving the below requirement when i execute on(Dax expression or any ways would do to derive the requirement)
Jan 1st - need the value of excluding of previoius 3 months of previous year
Feb 1st - No out put as Jan falls in the previous 3 months and has previous Year(November & December)
April 1st - No out put as Jan & Feb falls in the previous 3 months and also has previous Year(December)
March 1st - No out put as Jan, Feb and April falls in the previous 3 months and also has no months for current year.
May 1st - Display data of Jan and ignore the past 3 months (Feb, March & April) of current year.
June 1st - Display data of Jan & Feb and ignore the past 3 months (March, April & May) of current year .
and so on.
| Execution date | Jan 1st | Feb 1st | Mar 1st | Apr 1st | May 1st | June 1st | July 1st |
| Previous 3 months ignored | Oct | ||||||
| Nov | Nov | ||||||
| Dec | Dec | Dec | |||||
| Jan | Jan | Jan | |||||
| Feb | Feb | Feb | |||||
| Mar | Mar | Mar | |||||
| Apr | Apr | Apr | |||||
| May | May | ||||||
| June | |||||||
| Required Out in Report | Jan | No Data | No Data | No Data | Jan | Jan | Jan |
| Feb | Feb | Feb | |||||
| Mar | Mar | ||||||
| Apr | |||||||
| May | |||||||
| Jun | |||||||
| Jul | |||||||
| Aug | |||||||
| Sep |
Regards,
Santosh
3 Replies
Hi,
Ok even if i get Previous 3 months ignored & Required Out in Report
Example when executed in Jan 1st i must see
Columns
Dec,Nov,Oct & Sum of (Required Out in Report)
I have tried in this format but facing issue can Experts help me in below syntax
if Jan than (Dec,Nov,Dec and appropiate (Required Out in Report as given in excel below).
Else Feb than(...........................
Regards,
Santosh
