Forum Discussion

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
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

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