Forum Discussion
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.
3 Replies
Sivasai , You can have new column like
datediff(Maxx(filter(Table, [Date]< earlier([Date])), [Date]), [Date], day) +1
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.I need to calculate gamescount for last 6days, 5 days, like that,
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.
