Dynamic Filter Power BI Report based on Current Month
Dynamic Filtering Power BI Report based on Current Month I had a client requirement to filter Power BI report dynamically based on current month. And for which, I have created calculated column,which can do the trick as below IsCurrentMonth = IF(YEAR('rpt_BaseModel vw_AssetMonthly'[LastDayOfMonth]) = Year(TODAY()) && MONTH('rpt_BaseModel vw_AssetMonthly'[LastDayOfMonth]) = Month(TODAY()),"Yes","No") Note: You will need to tweak DAX as per your scenario