=Sum({<LItem= {‘Net Charge’}, xDate = {« >=$(=MonthStart(AddMonths(GDate, -12)))<=$(=MonthEnd(Addmonths(GDate, -1))) »}>} Amount)
count({<date_cloture={« >=$(vDate) »}>} distinct numero_ligne_concernee)
count({<[Planned Finish Date]= { » >= $(vStartExecutionWeek) <= $(=vEndExecutionWeek) »}>} [Work Order])



![[PowerBI][DAX] – CALCULATETABLE() dax powerbi fonction CALCULATETABLE](https://i0.wp.com/mybicoach.bwabwanet.fr/wp-content/uploads/2020/03/powerbi-dax-CALCULATETABLE.png?resize=218%2C150)
![[PowerBI] – Comment obtenir la date de mise à jour du rapport ?](https://i0.wp.com/mybicoach.bwabwanet.fr/wp-content/uploads/2020/03/powerbi-lastupdate-miseajour-item.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)