Forum Discussion

MiguelSaldana77's avatar
MiguelSaldana77
Icon for Resolver I rankResolver I
7 years ago
Solved

Table with different periods on columns

Hi everyone, It´s possible to present the same measure but with different period?   The image shows the sales of the month of November (synchronized with the monthly filter) and in the same table s...
Need Help
  • MiguelSaldana77's avatar
    MiguelSaldana77
    7 years ago

    Hi, I finally made the annual measure

     

    Anual Sales = CALCULATE(Sum(H_Viv[Sales]),FILTER(All(Std_Time),Year(Std_Time[Date])= Year(Std_Time[Date])))
MiaZhao's avatar
MiaZhao
Icon for Helper I rankHelper I
7 years ago

Hi ,

 

Have you tried to use function YTD() and MTD()?