Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Compare two months dta

Hello all,   I am new to Power BI, I have a task to develop a report comparing two months data.    I have a Report_date column and a Account column. Report_Date column has two dates values 202207...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

My Sample:

Here I suggest you to create a measure to filter your account list visual.

 

Measure = 
VAR _202207 = CALCULATETABLE(VALUES('Table'[Account]),FILTER('Table','Table'[Date] = 202207))
VAR _202208 = CALCULATETABLE(VALUES('Table'[Account]),FILTER('Table','Table'[Date] = 202208))
RETURN
IF(MAX('Table'[Account]) IN _202207 && NOT(MAX('Table'[Account]) IN _202208),1,0)

 

Create a table visual by [Account] column, add this measure into visual level filter and set it to show items when value = 1. Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.