Forum Discussion

kukszi's avatar
kukszi
Helper I
5 years ago
Solved

Applying two different calendars on the same data

Hi there, I have trouble with applying two different calendars on the same data. The sales data should be consolidated differently when it is presented to internal vs. external stakeholders. Th...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, kukszi 

    I believe you have a date-related column in your tables. If you have it, then the below measures might need to be fixed to match your model. However, the below can give you some ideas about how to approach your problem.

     

     

    Internal Stakeholders =
    CALCULATE (
    SUM ( Sales[Sales] ),
    TREATAS ( VALUES ( 'Calendar'[Reporting Week] ), Sales[Week] )
    )
     
    External Stakeholders =
    CALCULATE (
    SUM ( Sales[Sales] ),
    TREATAS ( VALUES ( 'Calendar'[Billing Week] ), Sales[Week] )
    )
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

  • Thejeswar's avatar
    Thejeswar
    5 years ago

    Hi kukszi ,

    You can also achieve it by using two different tables for the calendar.

     

    Join those tables to the data table like shown below.

     

    This can help you build the data as you need

     

     

     

     

Thejeswar's avatar
Thejeswar
Super User
5 years ago

Hi kukszi ,

You can also achieve it by using two different tables for the calendar.

 

Join those tables to the data table like shown below.

 

This can help you build the data as you need