Forum Discussion

gvb238's avatar
gvb238
Frequent Visitor
8 years ago
Solved

Rolling 3 Months Data

Hi Team, I Have one Requirement of Rolling 3 Months.  for this Requirement i have Date & Amount fields. For example If i filter June 2018 then it will show like this   Month&Year           AMT Ma...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi gvb238

    Here is an example

    1.create a date table and manage relationships between the two table

    date table = DISTINCT(Table1[date])

    2. add 'date table' [date] to the slicer, then create measures as below

    selected month = SELECTEDVALUE('date table'[date]) 

month difference = DATEDIFF(MAX([date]),[selected month],MONTH) 

if last three month = IF([month difference]>=1&&[month difference]<=3,1,0)

    3.then add the "if last three month" to the Visual Level filter, and set the condition to "show items when value is 1".

     

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi gvb238

Here is an example

1.create a date table and manage relationships between the two table

date table = DISTINCT(Table1[date])

2. add 'date table' [date] to the slicer, then create measures as below

selected month = SELECTEDVALUE('date table'[date]) 

month difference = DATEDIFF(MAX([date]),[selected month],MONTH) 

if last three month = IF([month difference]>=1&&[month difference]<=3,1,0)

3.then add the "if last three month" to the Visual Level filter, and set the condition to "show items when value is 1".

 

 

Best Regards

Maggie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, tried your solution, and sorry does not work :(

How can I get the selected date to every row in the table? I have it only on the row related to the selection, and then the next steps can be aplied :(

Thank you for help ...