Forum Discussion
Get count of previous date value.
Hey guys,
How to get the value count for a column for previous day and plot it in clustered column chart?
CountFromPreviousDay = CALCULATE(COUNT('Check table'[UID]),FILTER('Calendar',PREVIOUSDAY('Calendar'[DATES)))
I have a calendar table with all the dates and a check table with [Date] and [ID] column. I have ID incoming everyday except saturday and sunday. using the upper dax skips previous values for monday and friday. What is the ideal dax for this ?
[Calendar Table] : has all dates
[CHECK TABLE] : skips sat and sun
| date | id |
| 09/06/22 | 1a |
| 09/06/22 | 2a |
| 09/06/22 | 3a |
| 09/06/22 | 4a |
| 10/06/22 | 2a |
| 10/06/22 | 3a |
| 10/06/22 | 4a |
| 13/06/22 | 1a |
| 13/06/22 | 2a |
3 Replies
- amitchandak
Super User
Anonymous , Try like
CountFromPreviousDay = CALCULATE(COUNT('Check table'[UID]),PREVIOUSDAY('Calendar'[DATES))
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9check
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
Hi amitchandak ,
thankyou for your reply. I tried your solution. Somehow it gives fridays value for saturday as [previousday value] and monday it doesn't give a previous day value.
Regards,
Shubham
