Discussions – Power Platform – Dynamics Communities

Comparer données entre deux dates

Power Platform

Comparer données entre deux dates

Posted by DSC Communities on January 8, 2023 at 5:49 pm
- Younes HALLAI
  
  Member
  
  January 8, 2023 at 5:49 PM
  
  Bonjour,
  Je dois comparer plusieurs colonnes entre deux dates aujourd’hui et j-1. Je suis encore débutant, auriez vous des idées de comment faire ?
  
  Merci d’avance
  
  ——————————
  Younes HALLAI
  Apprentice data analyst
  ——————————
- Chi Truong
  
  Member
  
  January 9, 2023 at 10:59 AM
  
  Tu peux utiliser ca (et l<adapter a tes besions):
  
  ValueDoD% =
  IF(
  ISFILTERED(‘Tbl_Name'[InvoiceDate]),
  ERROR(“Please use date hierarchy or primary date column.”),
  VAR __PREV_DAY =
  CALCULATE(
  SUM(‘Tbl_Name'[Value]),
  DATEADD(‘Tbl_Name'[InvoiceDate].[Date], -1, DAY)
  )
  RETURN
  DIVIDE(SUM(‘Tbl_Name'[Value]) – __PREV_DAY, __PREV_DAY)
  )
  
  ——————————
  Chi Truong
  BI Optimization & Performance Analyst
  ——————————
  ——————————————-
DSC Communities replied 2 years, 9 months ago 1 Member · 0 Replies
0 Replies

Sorry, there were no replies found.

The discussion ‘Comparer données entre deux dates’ is closed to new replies.