Forum Discussion

Rdarshana's avatar
Rdarshana
Helper II
1 year ago
Solved

Native Query brings all data in tabular visual when currency conversion is applied.

Hi, I am wondering if anyone has faced this issue before. I have a SDM where I have a fact table containing data at date level.  Fact table is joined to the calendar table on Date ( inner join...
Need Help
Tips and Tricks
  • Rdarshana's avatar
    Rdarshana
    11 months ago

    All, 
    I wanted to inform that the issue was resolved. 

    A Date bridge table containing column with the first of month was added.
    This date bridge table was joined to the  Exchange Rate Table via a many-to-one join. 
    The date bridge table is then joined to the fact table via a one to many join. 

    The DAX query was then updated accordingly, and this resolved the issue. 


v-hjannapu's avatar
v-hjannapu
Community Support
1 year ago

Hi Rdarshana,
Thank you for the update.

Please take your time with the testing. If you run into any issues or need further clarification, feel free to reach out.

Regards,
Harshitha.

v-hjannapu's avatar
v-hjannapu
Community Support
1 year ago

Hi Rdarshana,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.


Thank you.