la fonction ADDCOLUMNS() permet d'ajouter une ou plusieurs colonnes calculées à une table existante. Elle crée une nouvelle table basée sur la table d'origine, mais avec des colonnes supplémentaires définies par des expressions DAX. Dans l'exemple ci-après la fonction ADDCOLUMNS() ajoute à une table de date créée à l'aide de la fonction CALENDAR() une colonne nommée "Date_+2J" qui ajoute deux jours à la colonne de la table de date. Dim_date =
ADDCOLUMNS(
CALENDAR("01/01/2024", "31/12/2024"),
"Date_+2J",
[Date] + 2
)
| Cookie | Durée | Description |
|---|---|---|
| cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
| cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
| cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
| cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
| cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
| viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
