The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi team,
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)
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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
112 | |
69 | |
48 | |
43 |
User | Count |
---|---|
188 | |
87 | |
77 | |
74 | |
60 |