Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Use January as target

Hi community,  My company decided to use Jauary 2020 as Target. We aim to make every month revenue reach the same level as it was on Janurary 2020. I have two problems regarding this issue to cons...
Need Help
  • gboppana's avatar
    gboppana
    5 years ago

    Anonymous  -

    For #1, can you clarify if you want the TARGET to be same as the 1 Jan 2020 always? Or do you want to display a constant value of  5.14 Million per day?



    For #2, you can get the desired result using Summarize and SUMX as below.

    TargetSum =
    SUMX(
    SUMMARIZE( d_date,
    d_date[year_month],
    "TargetTotal", [target]
    ),
    [TargetTotal]
    )
gboppana's avatar
gboppana
New Member
5 years ago

Anonymous  -

For #1, can you clarify if you want the TARGET to be same as the 1 Jan 2020 always? Or do you want to display a constant value of  5.14 Million per day?



For #2, you can get the desired result using Summarize and SUMX as below.

TargetSum =
SUMX(
SUMMARIZE( d_date,
d_date[year_month],
"TargetTotal", [target]
),
[TargetTotal]
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your time, and sorry for unclear explanation/

    5.14 is average revenue of Jnauary 2020, no a constant. Also if it's calculated from avarage, it should be able to filtered to show target of each department.