Forum Discussion

manojk_pbi's avatar
manojk_pbi
Helper V
1 year ago
Solved

Filter Value based on the previous month

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 bud...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    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
v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi manojk_pbi , 

Thanks for reaching out to the Microsoft fabric community forum.

Greg_Deckler  , 

Thanks for your prompt response

manojk_pbi 

I wanted to follow up and confirm whether you’ve had a chance to review the information  shared by Greg_Deckler  If you have any questions or need further clarification, please don’t hesitate to reach out.

If you're still encountering any challenges, feel free to let us know we’d be glad to assist you further.

Looking forward to your response.

Best regards,
Lakshmi

v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi manojk_pbi ,

 

We haven’t heard back from you regarding our last response, so I just wanted to check in to see if you were able to resolve the issue. If you have any further questions or need assistance, please feel free to let us know.

Best Regards,

Lakshmi