Forum Discussion

YasminYas's avatar
YasminYas
Helper I
7 years ago

Custom column for date and counts

I have 4 date columns along with ID Column completed date assigned date approved date Originated date I want to create a Calcluated column for Date in which if i filter the date i need to get th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

YasminYas , I have an idea of how to do this.  Can you provide a screenshot of what the result should look like? 

There will be a certain date in mind for the current filter context, and we need to manipulate the table to provide the right values each time.  

I want to ensure I have the correct value in mind as I build the DAX statement.

 

Best,

 

~ Chris

YasminYas's avatar
YasminYas
Helper I
7 years ago

Hello Chris
I am attaching sample Pbix file.
So i have created new date column but not giving correct values according to my requirement.
For D1 distict i have To Do count which has 1/04/2019  but when i change the new date filter from 01/28/2019 to till date iam not getting To do count as 1 I undestad that since it is not falling in that date range it is not showing but my end result should be it has to show count because it is in Open status 
https://www.dropbox.com/s/400tl3smdf35t31/Test.pbix?dl=0