Forum Discussion

SanjayZinjad's avatar
SanjayZinjad
Frequent Visitor
9 years ago
Solved

PY YTD Measures

Hi All, I have created below formula formula for calculation of Current Yeat Closed Account count and  PY same count for Closed Account .   YTD–Closed Account = CALCULATE(COUNT(Accountt[AccountNum...
Need Help
  • SanjayZinjad's avatar
    SanjayZinjad
    9 years ago

    Hi Xiaoxin Sheng,

     

    Thanks for your update.

     

    I have added the DataDimension and set relation between respective tables. I have changed the measures calculation for date dim and got the expected output.

     

    Regards,

    Sanjay.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi SanjayZinjad,

 

It will be help if you share some sample data and screenshots about your formula.

 

Regards,

Xiaoxin Sheng

SanjayZinjad's avatar
SanjayZinjad
Frequent Visitor
9 years ago

Hi Xiaoxin Sheng,

 

Thanks for your update.

 

I have added the DataDimension and set relation between respective tables. I have changed the measures calculation for date dim and got the expected output.

 

Regards,

Sanjay.