cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
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

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

 

View solution in original post

1 REPLY 1
Highlighted

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

 

View solution in original post

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

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