Forum Discussion
Native Query brings all data in tabular visual when currency conversion is applied.
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.
Hi Rdarshana,
I would also take a moment to thank grazitti_sapna, vojtechsima for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
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 the response has addressed your query, please Accept it as a solution so that other community members can find it easily.
Thank you
Harshitha.
Hi Rdarshana,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You.
Harshitha.
Still testing it,
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.