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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kborusu
Frequent Visitor

Dax Formula for pervious value(lag) in calculated column

I need to create one dax formula for column G(ABD) in the below screenshot. There are three cases to create this formula.

Case 1: First week of the quarter then total of DMD - History

Case 2: His >0 and not first week of the quarter then Above ABD- History

Case 3: His =0 then Above ABD-Above ABD/7

 

 

kborusu_2-1685465043655.png

 

 

 

0 REPLIES 0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.