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])))
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi MiguelSaldana77

 

Just using an ALL() on the month column should do the trick. Something like 

SUM(Tables1[Sales], ALL(Table1[Month])

Be careful thought with the year. If you show the structure of your data model we could be more precise with the solution

 

 

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

    Thanks @AIB well, the structure is very simple, I have a Fact Table and differents Catalogs for the differents dimensions and I have a Catalogo for the Time.

    So, If I use a week filter, I have to do an calculated measure ussing that formula ?

    • Vvelarde's avatar
      Vvelarde
      Icon for Community Champion rankCommunity Champion
      7 years ago

      MiguelSaldana77

       

      Hi, create a Basic Measure like SUM(Sales).

       

      And after that create measures with the desired period.  Monthly, Anually, etc

       

      Regards

       

      Victor

       

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

        Thanks for your help to everyone

         

         

        I was working with the formulas and I got this for the Monthly Measure, but I couldn´t made work the anual measure.

        Could anyone help with the annual measure, please.

         

        Monthly Sales = CALCULATE(H_Viv[Sum Sales],FILTER(All(Std_Time),MONTH(Std_Time[Date])= MONTH(MAX(Std_Time[Date]))))
         
        The annual doesn´t work 
        Annual Sales = CALCULATE(H_Viv[Sum Sales],FILTER(All(Std_Time),Year(Std_Time[Date])= Year(MAX(Std_Time[Date]))))