Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
lherbert501
Helper V
Helper V

DAX Previous month + value greater than 0

Hi there,
 
Could somebody please help me with my dax query? I have my simple query below which works fine.
 
I want it to be able to return if the output is equal to 0, then move to the next day that has a value greater than 0
 
 
2 Months ago Sales =
var _PrevMonth =  DATEADD(RS_Dates[DateFull],-1,MONTH)
return
CALCULATE([CurrentMonthSales], _PrevMonth)
 
Thanks
1 REPLY 1
Thennarasu_R
Responsive Resident
Responsive Resident

Hi @lherbert501 

you Could create this Measure ,

Thennarasu_R_0-1678295591133.png

Test = CALCULATE(SUM(Refference[Value]),DATEADD('Dim_ date'[Date],-1,MONTH),Refference[Value]>0)



If this helpful to you,Give Accepeted a Solution.

Thanks,
Thennarasu

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.