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 show the annual sales, Is it possible?

 

 

Thanks

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])))

7 Replies

  • 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

         

  • MiaZhao's avatar
    MiaZhao
    Icon for Helper I rankHelper I
    7 years ago

    Hi ,

     

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

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    MiguelSaldana77,

     



    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 show the annual sales, Is it possible?

     

     

    Thanks

    Could you share more details about relationship between Actual Month and Actual Year? For example, which kind of DAX formula are you using? In addtion, if possible, could you share the original table, not the cahrt? Mark sure mask the sensitive data.

     

    Regards,

    Jimmy Tao