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.
Hoping someone can help, I imagine it's simple but have been trying for ages, and cant find anything online either.
I have a table with a list of clients, all with their own fiscal year. I have another (linked) table with values by period. Finally, i have a table with a list of years to select.
I want to sum up the fiscal year by client based on a dropdown, so for example, they select 2019, and it totals the 2019 client fiscal years (some will start in jan 2019, others in apr 2019 etc). I know the dropdown piece, i'm just struggling with how to essentially calculate customer individually with one measure. Can anyone point me in the right direction?
This will depend heavily on your data and how it is structured. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But in general, you would do something along the lines of:
Measure =
VAR __Client = MAX('Table'[Client])
VAR __Table =
SWITCH(__Client,
"One",ALL('TableOneClient'),
"Two",ALL('TableTwoClient)
)
RETURN
<some calculation>
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |