Forum Discussion

spagad6263's avatar
spagad6263
Icon for Post Patron rankPost Patron
10 months ago
Solved

How can I calculate table total without first month?

Hi,   I have a table showing last 13 months sales from Sep 2024 to Sep 2025. I would like to set the first month color as RED, which is already done with the help from Power BI community. Now I wou...
Need Help
  • Ahmedx's avatar
    Ahmedx
    10 months ago

    pls try this
    VAR _MaxDate = EOMONTH( MAX('Calendar'[Date]),0)
    RETURN
    CALCULATE( [_Sales],
    KEEPFILTERS(DATESINPERIOD('Calendar'[Date],_MaxDate,-12,MONTH)))

spagad6263's avatar
spagad6263
Icon for Post Patron rankPost Patron
10 months ago

Can soeone suggest how I could upload powerbi app file? Thanks

PBI_Consultant's avatar
PBI_Consultant
Frequent Visitor
10 months ago

You can create and update an app in the Power BI service. You can also upload a Power BI report file to the workspace and include it in the app. However, you cannot directly upload a Power BI app file itself. Could you please clarify what exactly you're trying to do?
Thanks