Forum Discussion
Exchnage rate issue
I have created two measure for exchange rate. One of them is Total Income Transferred - Actual. This works fine when I select any date from dim exchange date. The value calculated is correct. Total...
Hi kumarm,
In fact, since power bi data mode table not existed row/column index. So if you use lastnonblank function and try to pick up the 'last' records, it may not return the result you wanted. You can take a look at the below blog to know more about this function.
As you said it has rolled up your records and get the wrong result, what Target_Value value you wanted? AFAIK, power bi dax formula contains a few functions that include iterator feature, if you not wan to rolling up the records, you can consider using other functions instead sumx.
Regards,
Xiaoxin Sheng
I still have the issue.Can anybody help me on this.