Forum Discussion

iteety's avatar
iteety
Regular Visitor
3 years ago
Solved

How to create daily data from MTD data?

Dear All,   I got a salesman outlet visit data as MTD which is accumulated daily. How could I create new column or use DAX formula for salesman outlet daily visit? (calculation is outlet_visit_MTD(...
  • ThxAlot's avatar
    ThxAlot
    3 years ago

    Pay attention to the situation that there are gaps between dates.

    Daily.pbix

     

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

iteety Please try this
calculate(TOTALMTD(SUM(outlet_visit_MTD(day n)),outlet_visit_MTD[yyyyMMdd]),ALLEXCEPT(outlet_visit_MTD,outlet_visit_MTD[Saleskey]))

iteety if this helps you please mark as a solutions.