tag:blogger.com,1999:blog-3721871707048712457.post8646804958462971486..comments2024-03-28T00:39:48.395-04:00Comments on Breaking BI: Power BI/PowerPivot: Using LOOKUPVALUE() to Emulate RelationshipsBreaking BIhttp://www.blogger.com/profile/02551920506874509998noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-3721871707048712457.post-44462501449585459882018-04-09T07:52:01.838-04:002018-04-09T07:52:01.838-04:00Although I haven't tried the Lookupvalue funct...Although I haven't tried the Lookupvalue function yet, I use an unrelated date table in my model because I have lots of dates in my tables and that would require building several relationships and switching between them to do my calculations. That is why I choose to use Calculate and filter dates as [date field] <= MIN(Calendar(Date)), for example. And it works fine FAIK.<br />thanks for your post.Anonymoushttps://www.blogger.com/profile/07000077761807858098noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-5867384327165890642018-03-04T18:01:10.057-05:002018-03-04T18:01:10.057-05:00If there are two fields in the same table which ca...If there are two fields in the same table which can be classified in the same context e.g. eye colour and hair colour may be classified using the 'colours' table.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-78128633642292426612017-09-15T08:12:28.928-04:002017-09-15T08:12:28.928-04:00Great post. Thanks for sharingGreat post. Thanks for sharingJPBhttps://www.blogger.com/profile/00914060725348770011noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-54673159795927779352017-04-19T19:24:53.532-04:002017-04-19T19:24:53.532-04:00It opened my mind, amazing usage! Thank you so muc...It opened my mind, amazing usage! Thank you so much for the great job!Anonymoushttps://www.blogger.com/profile/04701496212980207662noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-87766182549548830792017-01-11T12:09:04.700-05:002017-01-11T12:09:04.700-05:00Hello
The biggest disappointments in our lives are...Hello<br />The biggest disappointments in our lives are often the result of misplaced expectations. This is especially true when it comes to our relationships and interactions with others.Read more-<a href="http://doodledandee.com" rel="nofollow">Sex and Relationship Advice For Women</a><br />Anonymoushttps://www.blogger.com/profile/10536458889705157212noreply@blogger.com