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 😊
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 😊