Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Add the amount from the previous month to the following month, depending on the status.
Example: status = "OPERATE" and the month selected is greater than the current month, add 740 to the value of the previous month.
Solved! Go to Solution.
Amount with Status = //Try this
VAR CurrentMonth = SELECTEDVALUE('Calendar'[Month])
VAR PreviousMonthAmount = CALCULATE(SUM('Table'[Amount]), 'Calendar'[Month] = CurrentMonth - 1)
VAR CurrentStatus = SELECTEDVALUE('Table'[Status])
RETURN
IF(
CurrentStatus = "OPERATE" && CurrentMonth > MONTH(TODAY()),
PreviousMonthAmount + 740,
PreviousMonthAmount
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Thanks for responding, but it didn't work.
Amount with Status = //Check this one
VAR CurrentMonth = SELECTEDVALUE('Calendar'[Month])
VAR PreviousMonthAmount =
CALCULATE(SUM('Table'[Amount]),
FILTER(ALL('Calendar'),'Calendar'[Month] < CurrentMonth))
VAR CurrentStatus = SELECTEDVALUE('Table'[Status])
RETURN
IF(
CurrentStatus = "OPERATE" && CurrentMonth > MONTH(TODAY()),
PreviousMonthAmount + 740,
PreviousMonthAmount
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Amount with Status = //Try this
VAR CurrentMonth = SELECTEDVALUE('Calendar'[Month])
VAR PreviousMonthAmount = CALCULATE(SUM('Table'[Amount]), 'Calendar'[Month] = CurrentMonth - 1)
VAR CurrentStatus = SELECTEDVALUE('Table'[Status])
RETURN
IF(
CurrentStatus = "OPERATE" && CurrentMonth > MONTH(TODAY()),
PreviousMonthAmount + 740,
PreviousMonthAmount
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |