Forum Discussion

VJ_2692's avatar
VJ_2692
Frequent Visitor
3 years ago

Approximate Beg Backlog and Approximate ending Backlog DAX not working as required

Hi, I am new to power bi. I have a scenario in which  I have to calculate Approximate Beg Backlog & Approximate Ending Backlog. The dax formulas for both are as follows: Approximate Beg Backlog = A...
Circular dependency
DAX Power BI
Dynamic calculation
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

VJ_2692 , You should create a date table and measures like

 

CALCULATE(Sum(Table[Value]) ,DATEADD(Date[date],-7,DAY))

 

CALCULATE(Sum(Table[Value]) ,DATEADD(Date[date],-14,DAY))

 

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s