cancel
Showing results for
Did you mean:
Highlighted
Helper I

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
MVP

## Re: Help 3 questions/problems

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

Highlighted
MVP

## Re: Help 3 questions/problems

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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors