Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
7 years ago

Measure help

  Hi team, Zubair_Muhammad    below is how my current measure , i need to add  filter for Year into this measure that means when i select my slicer for  FY18 and Q1, it shows me only FY18 Q1 res...
Need Help
Show and Tell
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi vjnvinod ,

 

I create a sample using the measure to calculate the value of next year. And I put the values into a table visual.

 

Create a new table.

Table = CALENDARAUTO()

Create a measure

DATEADD = CALCULATE(SUM(Table1[value]),DATEADD('Table'[Date],1,YEAR))

Note: the date in slicer and table is from Table 1.

 

Best Regards,

Xue Ding 

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