Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello,
I am trying to perform what is seemingly an easy calculation but I cannot get there in DAX.
I am reading several forecats files, to which I give a version: "n" for this month, "n-1" for last month, etc.
I also have an actual spending table, with spending per month up to the latest month of available data (so no versioning).
What I need to do it to be able to sum up the actuals but only up to the date of the version selected (or version used as a legend in a chart is what I would like to achieve, to show the different curves of forecast + actual per month by file version).
I have a table with file versions that I am reading, that I have now included in my date table (which I hope is the correct way of doing thigs):
The Actuals table just has 4 columns: Project Number, Date, Spending and Year
then I have tried to created a measure for summing the actuals, but it is not working 😞
Can you please guide me in how to do this properly?
Thanks!
Kind regards
Valeria
Hi @ValeriaBreve check bracket at start and at end in part VAR VersionSelected = (SELECTEDVALUE(DateTable[EOM Date])). I hope this help.
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.