Forum Discussion
Solved
Dax
Hi I have games column and date column I need to create a calculate column of games count, with respective date difference like last 6 days, 5 days with respective today's date..in dax code
Hi Sivasai ,
Based on your description, I have created a simple sample:
Please try:
last 5 days = CALCULATE(DISTINCTCOUNT('Table'[games]),FILTER('Table','Table'[date]<TODAY()&&'Table'[date]>=TODAY()-5)) last 6 days = CALCULATE(DISTINCTCOUNT('Table'[games]),FILTER('Table','Table'[date]<TODAY()&&'Table'[date]>=TODAY()-6))Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jianboli-msft
Community Support
Community SupportHi Sivasai ,
Based on your description, I have created a simple sample:
Please try:
last 5 days = CALCULATE(DISTINCTCOUNT('Table'[games]),FILTER('Table','Table'[date]<TODAY()&&'Table'[date]>=TODAY()-5))
last 6 days = CALCULATE(DISTINCTCOUNT('Table'[games]),FILTER('Table','Table'[date]<TODAY()&&'Table'[date]>=TODAY()-6))
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.