cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Govardhaninew1
Frequent Visitor

Mismatching the values from cube to Power BI reoport

Hi Team, I am facing problems like the discrepancy between the Bi report and the cube. I connected the cube by Live connection. Total amount NZD currency values are not matching? in cube and BI

Cube values:                  In BI:

Govardhaninew1_0-1652181455119.png  Govardhaninew1_1-1652181557886.png

Govardhaninew1_2-1652182195782.png

Please me.

Thanks.

 

 

3 REPLIES 3
Govardhaninew1
Frequent Visitor

Hi Evelyn Qin, thanks for your message. Amount NZD:= (Currency Amount)* (Currency Rate). I have used this formula in the cube and nothing changed in PBI as it's a live connection. Thanks

Eyelyn9
Community Support
Community Support

Hi @Govardhaninew1 ,

 

Could you please provide the formula for Total amount in NZD used both in Cube and PBI?

Eyelyn9_0-1652407946364.png

 

Refer to:
How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

 

 

Best Regards,
Eyelyn Qin

is there any idea how to bring the values same(match) both in the cube and BI

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors