Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
vjnvinod
Impactful Individual
Impactful Individual

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 result and similarly for FY19 as well

currently the below measure is adding the value of Q1 of FY18 and FY19 (not filtering out correctly)

 

Cumulative =
   switch(
   true(),
   SELECTEDVALUE('Account Listing'[Quarter])="Q1",[Q1_GteRevenue],
   SELECTEDVALUE('Account Listing'[Quarter])="Q2",[Q2_GteRevenue]-[Q1_GteRevenue],
   SELECTEDVALUE('Account Listing'[Quarter])="Q3",[Q3_GteRevenue]-[Q2_GteRevenue],
   [Gterrevenue]
   )
2 REPLIES 2
v-xuding-msft
Community Support
Community Support

Hi @vjnvinod ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

 

Best Regards,

Xue

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

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.
v-xuding-msft
Community Support
Community Support

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()

1.png2.png

Create a measure

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

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

3.jpg4.png

 

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.

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors