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.
Hi All,
I have a requirement where when the user selects a particular Fiscal period like FY 17 - Q1 , it should automatically get the previous 2 quarters data with the current one
Slicer Value Selected : FY17-Q1
Data To be Shown:
Fiscal Qtr Revenue
FY16 Q3 - 100$
FY16 Q4 - 80 $
FY17 Q1 - 90 $
Our calendar is a customized calendar and does not start on the first day of every month for each fiscal period .
Any help is appreciated
I have tried different options but came up blank in acheiving this .
Solved! Go to Solution.
Hi @rajesh2001,
I think we need to create two tables in this scenario. The tables look like this:
The bridge table could use this formula:
BridgeTable = values(ForSlicer[column2])
Finally, create relationships(the direction should be "both"). ForSclier->BridgeTable->Calendar.
Please refer to this post: problem-with-calculation-many-to-many. It's almost the same with yours.
Best Regards!
Dale
Hi @rajesh2001,
I think we need to create two tables in this scenario. The tables look like this:
The bridge table could use this formula:
BridgeTable = values(ForSlicer[column2])
Finally, create relationships(the direction should be "both"). ForSclier->BridgeTable->Calendar.
Please refer to this post: problem-with-calculation-many-to-many. It's almost the same with yours.
Best Regards!
Dale
Thanks a lot Dale . This solution helps
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |