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.
I have 3 tables as follows:
TABLE DATE
DATE |
1/1/2020 |
2/1/2020 |
3/1/2020 |
..... |
..... |
TABLE VOLUMES
DATE | VOLUMES |
1/1/2020 | 10 |
2/1/2020 | 15 |
3/1/2020 | 50 |
... | ... |
... | ... |
TABLE COSTS
DATE | COST | VOLUMES YTD (calculated colum) |
1/1/2020 | 10 | 75 |
2/1/2020 | 15 | 75 |
3/1/2020 | 50 | 75 |
... | ... | |
... | ... |
They have 1:many relation from table Date to both tables Costs and Volumes.
I need to add a calculated column in table COSTS, named Volumes YTD, containing the sum ytd of volumes for a selected period.
Example: if the user wanted to read the volumes ytd from Jan to March, the result would be 75 (in red in the example above) for any row. Besides, I'd like the user to be able to select the ytd period to be considered, meaning that if the user selects February YTD, then the table COST appears as follows:
DATE | COST | VOLUMES YTD (calculated column) |
1/1/2020 | 10 | 25 |
2/1/2020 | 15 | 25 |
3/1/2020 | 50 | 25 |
... | ... | |
... | ... |
Many thanks
Mark
As far as I am aware calculated columns are "calculated" when the model is built.
So the unless the user is rebuilding the model with some kind of parameter table you can't do what you are describing.
Depending on what you are trying to do maybe a measure is a better way to go?
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 |
---|---|
40 | |
26 | |
20 | |
14 | |
8 |
User | Count |
---|---|
76 | |
48 | |
46 | |
20 | |
16 |