Forum Discussion

Stuk's avatar
Stuk
Icon for Helper I rankHelper I
9 years ago
Solved

Help 3 questions/problems

Hello everyone !  - my calendar don't work anymore "calendrier = CALENDAR(01/01/2015; TODAY())" - when he will works how can i use it to filter a graphics to the 14 last days - Do you have any go...
Need Help
  • Datatouille's avatar
    Datatouille
    9 years ago

    Hi Stuk

     

    1) Calendrier = CALENDAR( "01/01/2015" , TODAY() ) works. You need the "" ! 

    Calendrier = CALENDAR( DATE(2015;1;1) , TODAY() ) also works !

     

    2) Supposing you retrieve the last 14 days in a separate table called Last14days: 

    Last14days = CALCULATETABLE( Calendrier ,  DATESINPERIOD( Calendrier[Date] ,TODAY() ,-14 , DAY) ) works fine.

     

    You can then use :

    - this brand new table Last14days as a filter in a measure with a calculate : SalesofLast14Days = Calculate ( [Total Sales] , Last14Days )

    - or the date column of Last14days table as an X axis in your chart(s).

     

    You can adjust the parameters of DatesInPeriod() whether you want to start from today() or today()-1 !

     

    3) Please refer to my reply to this post for DAX resources.

     

    Hope It helps you :) Feel free to ask if you have any questions!

     

    Tristan

    Data & BI consultant at AZEO

     

Datatouille's avatar
Datatouille
Icon for Solution Sage rankSolution Sage
9 years ago

Hi Stuk

 

1) Calendrier = CALENDAR( "01/01/2015" , TODAY() ) works. You need the "" ! 

Calendrier = CALENDAR( DATE(2015;1;1) , TODAY() ) also works !

 

2) Supposing you retrieve the last 14 days in a separate table called Last14days: 

Last14days = CALCULATETABLE( Calendrier ,  DATESINPERIOD( Calendrier[Date] ,TODAY() ,-14 , DAY) ) works fine.

 

You can then use :

- this brand new table Last14days as a filter in a measure with a calculate : SalesofLast14Days = Calculate ( [Total Sales] , Last14Days )

- or the date column of Last14days table as an X axis in your chart(s).

 

You can adjust the parameters of DatesInPeriod() whether you want to start from today() or today()-1 !

 

3) Please refer to my reply to this post for DAX resources.

 

Hope It helps you :) Feel free to ask if you have any questions!

 

Tristan

Data & BI consultant at AZEO