Forum Discussion

Qazybek's avatar
Qazybek
Frequent Visitor
7 years ago
Solved

Reverse calculation in DAX

Dear friends,   Does somebody know how to realize reverse calculations in DAX?   Like this
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI Qazybek,

     

    There are lot of difference in dax formula between power bi and excel pivot table, some functions only available to excel and some dax functions only works on power bi side.

     

    I don't think a complex formula can works well on them at same time. Can you please share a sample file to test?

     

    In addition, you can also take a look at following links about circular dependency:

    Avoiding circular dependency errors in DAX

    Understanding Circular Dependencies in Tabular and PowerPivot

     

    Regards,

    Xiaoxin Sheng

Qazybek's avatar
Qazybek
Frequent Visitor
7 years ago

Hi Anonymous,

 

Thank you for the reply! Somehow formulas on my Excel sheet disappeared, so I updated the link :)

 

I think that I am very close to the final solution but can't get the final calculation. The error is a circular dependency.

Is there any way to make it differently?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Qazybek,

 

There are lot of difference in dax formula between power bi and excel pivot table, some functions only available to excel and some dax functions only works on power bi side.

 

I don't think a complex formula can works well on them at same time. Can you please share a sample file to test?

 

In addition, you can also take a look at following links about circular dependency:

Avoiding circular dependency errors in DAX

Understanding Circular Dependencies in Tabular and PowerPivot

 

Regards,

Xiaoxin Sheng

  • Qazybek's avatar
    Qazybek
    Frequent Visitor
    7 years ago

    Hi Anonymous,

     

    Thank you very much for your help!