Forum Discussion

Hemant_Jaiswar's avatar
Hemant_Jaiswar
Helper I
1 year ago
Solved

DAX Help: Average RRP Over Last 3 Months Excluding Latest, Dividing by Available Months Only"

  I’m working on a Power BI report where I need to calculate the average RRP for the last 3 months from selected date , but I want to exclude the selecetd month in the data. Here's what I mean with ...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Hi Hemant_Jaiswar,

    Thank you for reaching out to us through the Microsoft Fabric Community Forum.

    Kindly find attached the screenshot and the PBIX file, which may assist in resolving the issue:


    If you find our response helpful, we request you to mark it as the accepted solution and consider giving kudos. This will be beneficial for other community members who may have similar queries.

    Thank you.

Hemant_Jaiswar's avatar
Hemant_Jaiswar
Helper I
1 year ago

ajaybabuinturi here is the sample data

Year Month StoreName Sales
2024 January Store A 12000
2024 January Store B 9500
2024 February Store A 13400
2024 February Store C 8900
2024 March Store B 10000
2024 March Store C 9200
2024 April Store A 11000
2024 May Store C 9700
2024 May Store B 10200
2024 June Store A 12500
2024 July Store B 10800
2024 August Store C 9500
2024 September Store A 11900
2024 October Store C 9800
2024 November Store A 12700
2024 December Store B 11500