Forum Discussion
Dynamically filter on current month - 1
Greeting lovely members . i have a simple power bi report that i want to make it Dynamic . My data base is simple , here is a sample : let's say this is the table where it contains the dat...
Here is the trick :
Current month test = if (FORMAT(DATEADD('Date'[Full date],1,MONTH),"mm yyyy")=FORMAT(TODAY(),"mm yyyy"),"true","false")Last year Current month test = if (FORMAT(DATEADD(DATEADD('Date'[Full date],1,YEAR),1,MONTH),"mm yyyy")=FORMAT(TODAY(),"mm yyyy"),"true","false")all i need to do is to filter my visuals based on these 2 columns and it solves the trick 😊
Hi, Anonymous
I hope I understand your question correctly.
please try to follow the below.
if it does not work, please let me know.
yourmeasure Previous Month = CALCULATE( yourmeasure, DATEADD('Table'[Date], -1, MONTH))
yourmeasure YTD until previous month =
CALCULATE( yourmeasure, FILTER(ALLSELECTED('Table'[Date]), 'Table'[Date] <= EOMONTH(, -1) && 'Table'[Year] = MAX('Table'[Year])))
MAX('Table'[Date])
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
First of all Thanks for you answer .
i think i find a way to solve it , i was thinking to add a column in my Date table called Previous Month that have values (True or false) and based on that column i filter my visuals , can u help me build that calculated columns .
i was able to create a column that return true or false for the current month using this Dax funtion :
Current month test = if (FORMAT('Date'[Full date],"mm yyyy")=FORMAT(TODAY(),"mm yyyy"),"true","false")Here is the trick :
Current month test = if (FORMAT(DATEADD('Date'[Full date],1,MONTH),"mm yyyy")=FORMAT(TODAY(),"mm yyyy"),"true","false")Last year Current month test = if (FORMAT(DATEADD(DATEADD('Date'[Full date],1,YEAR),1,MONTH),"mm yyyy")=FORMAT(TODAY(),"mm yyyy"),"true","false")all i need to do is to filter my visuals based on these 2 columns and it solves the trick 😊