Dax

[Sivasai]

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 

[v-jianboli-msft · Accepted solution]

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.

[amitchandak]

@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.

[Sivasai]

I need to calculate gamescount for last 6days, 5 days, like that,