Forum Discussion
Count The Number Of Days In a Dataset
- Anonymous2 years ago
Hi, MichelleRoberts
Thanks SivaMani . Have you solved your problem? I read your previous reply, you can create a DAX expression similar to the following:
First, you can create a measure based on the current Table Visual, as shown in the following image:
Use a DAX expression similar to the following:
Here are the results:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I did and got the same exact results.
Can you remove .[Date] from your calculation?
- MichelleRoberts2 years agoRegular Visitor
I removed the .[Date] and got this result:
- SivaMani2 years agoResident Rockstar
MichelleRoberts ,Is there any filter applied in the report and if no filter is applied what should this measure show?
- MichelleRoberts2 years agoRegular Visitor
The only filter is that the transaction date is in February. I want it to return the number 26 since there were 26 days where we had transactions in the month of February. Does that make sense?