cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hbroich
Frequent Visitor

Calculation dependent on the Value of the previous month

Hi all,

I have a question referring a calculation.
The base is row called "Netting Amount", and the "Date" Columns (hierachy from day to year).

I want to create a measure for the following calculation on a monthly base:

If "Sum of previous month" (how to define the variable for the previous month?) > 0, then 0,
If "Value on the first day of the following month" is not 0, than 0, else show the cumulative amount of all values until this day.

Thank you very much for your help!
BR

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@hbroich Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

1 REPLY 1
parry2k
Super User
Super User

@hbroich Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!