Creating a dynamic date filter for the current day

[Anonymous]

Hi!

I am having trouble with the date filter I have created. It is dynamically made with DAX commands to filter data according to the current date.

 

I have attached a sample power bi file of this filter. The issue I am having is I would like the filter to only show the data with dates that occur prior to and including the selected date. 

https://drive.google.com/file/d/1dJQOgVHnbxpcQ3QbJ3qdMbxajMPoWsHI/view?usp=sharing

Thank you for helping!!

[v-yalanwu-msft]

Hi, @Anonymous ;

You could create another measure.

count = COUNTROWS( SUMMARIZE(FILTER('data',[flag]=1),[date],[name]))

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

You could create a flag measure.

flag = 
var _max=CALCULATE(MAX('data'[date]),ALL('data'))
var _year= IF(MAX('FilterYear_Table'[Disp Year])="Today’s Year",YEAR(_max), CONVERT(MAX('FilterYear_Table'[Disp Year]),INTEGER))
var _month= IF(MAX('FilterMonth_Table'[Disp Month])="Today’s Month",MONTH(_max),MONTH(  MAX('FilterMonth_Table'[Disp Month]) & " 1"))
var _day= IF(MAX('FilterDay_Table'[Disp Day])="Today’s Day",DAY(_max),CONVERT(MAX('FilterDay_Table'[Disp Day]),INTEGER))
return IF(MAX([date])<=DATE(_year,_month,_day),1,0)

Then apply it into filter.

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Thank you for your help! I was wondering if how would you create a card that would display the total number of names displayed in the chart for the selected date? 

When I tried duplicating the chart and coverting the data into a card, the card only seems to display the overall total number of data values instead of the number of data values displayed.

Thank you!

[Anonymous]

I tried it with the power bi file, but the total only displays the overall total of the entire data set. I attached a copy of the file.

Thank you for your help!

https://drive.google.com/file/d/13fXAgCnV24fWR33fKVph7FqFHF56zOnb/view?usp=sharing

[amitchandak]

@Anonymous , You have create these in you table 

Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)

Month Type = Switch( True(),
Eomonth([Date],0)= Eomonth(Today(),0),"This Month" ,
month([Date]) & "" // or// format([Date],"mmm")
)

Month Type = Switch( True(),
[Date]= Today(),"This Day" ,
Day([Date]) & ""
)

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

[Anonymous]

Hi! Thank you for your help! I was wondering if there was a way for me to also display all the data that falls on the dates leading up to the selected date as well?