Tag: variable
Comment utiliser une variable dans une clause WHERE ?
1. don't set the variable in the script to an empy value (let Myvar = '';)
2. use right notation in Where Clause:
WHERE (Field1 =...
Comment sélectionner plusieurs valeurs d’une dimension ?
In this post, I will demonstrate how to programmatically select multiple values in a field.
We know that manually, we can select multiple field values...
Insérer dans une variable
Select foo from table;
let variable = peek('foo',0,'tmp');
drop table tmp;
DATA:
Select baa from table where baa < $(variable);

![[PowerBI][BI] – IF() powerbi dax fonction if](https://i2.wp.com/mybicoach.bwabwanet.fr/wp-content/uploads/2020/03/powerbi-dax-if.png?resize=218%2C150)
![[PowerBI][DAX] – DISTINCTCOUNT() dax powerbi fonction distinctcount](https://i0.wp.com/mybicoach.bwabwanet.fr/wp-content/uploads/2020/03/powerbi-dax-distinctcount.png?resize=218%2C150)


![[PowerBI][DAX] – Comment compter le nombre de ligne d’une table ?](https://i2.wp.com/mybicoach.bwabwanet.fr/wp-content/uploads/2020/01/powerbi-dax-countrows-logo-1.png?resize=100%2C70)