Hi ,I tried with many options using the references but could not succed.I have single table having budget and forecast values defined for entire year. I would like present the previuos months budget in a card for the current month. I am not able to get the proper measure. The number should change if any other dimensions selected from the same table. Expecting the measure should display Jul data.1/1/202517.9043772/1/202523.787355973/1/202552.45872394/1/202582.804330855/1/2025106.75676726/1/2025119.54855137/1/2025177.82641488/1/2025342.54314039/1/2025373.344217210/1/2025379.188668311/1/2025654.98176312/1/2025746.7441488

manojk_pbi So like this?Previous Month's Budget = VAR __Month = MONTH( TODAY() ) VAR __Year = YEAR( TODAY() ) VAR __Date = DATE( __Year, __Month, 1 ) VAR __Result = MAXX( FILTER( ALL( 'Table' ), [Date] = __Date ), [Budget] ) RETURN __Result

Filter Value based on the previous month | Microsoft Fabric Community

Forum Discussion

Related content

Getting value for previous year based on value name and year slicer

Previous Row Value Dax

Previous Day Value

Previous Day Value

Cumulative Filter for previous values