Forum Discussion
Dynamic baseline calculation
I have a dax cacualtion that currenty finds and averages the baseline for events . I am trying to figure out how to create a dynamcic baseline where I can choose what years are included in the basel...
Hi mikess1281 ,
You can refer the following links to get it by creating line chart with analytic line.
Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn
DynamicBaseline =
CALCULATE(
AVERAGE(YourTable[EventValue]),
FILTER(
YourTable,
YourTable[Year] IN VALUES(YearTable[Year])
)
)Solved: Dynamic baseline and UOM - Microsoft Fabric Community
Best Regards