CM=
DECLARE(
CurrentMonth, SUBSET_MAX([RankMonth]),
SUBSET_SUM([Sales], SUBSET2([Date],[RankMonth],[Date],CurrentMonth)))
LM=
DECLARE(
CurrentMonth, SUBSET_MAX([RankMonth]),
SUBSET_SUM([Sales], SUBSET2([Date],[RankMonth],[Date],CurrentMonth-1)))
DeclareSubset.iok | 22K | |
sideBySide.JPG | 52K |
example.iok | 10K |
IF(
[YearMonth]=DATETOTEXT(TODAY,"yyyyMM"),"Current Month",
[YearMonth]=DATETOTEXT(DATEADD(TODAY,-1,"month"),"yyyyMM"),"Previous Month",
null)
IF(
[YearMonth]=DATETOTEXT([Month of report],"yyyyMM"),"Current Month",
[YearMonth]=DATETOTEXT(DATEADD([Month of report],-1,"month"),"yyyyMM"),"Previous Month",
null)
example.iok | 10K | |
example2.iok | 10K |
It looks like you're new here. If you want to get involved, click one of these buttons!