Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (11.1k points)
Power Bi is showing a cached wrong value on Power Query,because I filtered the mapping tables to only one row,I am clearing the cache and its not changing anything,How can I do that?

1 Answer

0 votes
by (22.5k points)

Hi,use the following measures

= Table.NestedJoin(#"Changed Type", {"CombinedForMerge"}, XXXXMappings, {"CombinedForMerge"}, "Changed Type", JoinKind.LeftOuter)

and

= Table.NestedJoin(XXXXMappings, {"CombinedForMerge"}, #"Changed Type", {"CombinedForMerge"}, "XXXXMappings", JoinKind.RightOuter) 

Want to learn more about Power BI? Check out today: Power BI course       

Related questions

0 votes
1 answer
asked Feb 28, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Mar 29, 2021 in BI by Chris (11.1k points)

Browse Categories

...