Help 3 questions/problems

[Stuk]

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 good docs for dax language because i want to create column with the datas of others column of my database 

[Datatouille · Accepted solution]

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