Forum Discussion

MacJasem's avatar
MacJasem
Icon for Advocate II rankAdvocate II
3 years ago
Solved

Flatlined values in a MTD table

Hi Guys Whats the esiest reusable method to discontinue flatlined values in YTD/MTD/WTD tables/graphs/BarCharts, such as this example: Data stops at 2. of February and thereby the chart flatl...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, MacJasem 

     

    You can try the following methods.

    Measure = IF([TotalSalesValueMTD]=0,0,1)

    Result:

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, MacJasem 

 

You can try the following methods.

Measure = IF([TotalSalesValueMTD]=0,0,1)

Result:

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.