Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated Table Creation

Hello, I have an SQL query and there are many inner joins.  But my problem is about an outer apply under the inner joins.  You can find below example code:   outer apply ( select top 1 * from ...
Need Help
Show and Tell
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You may create calculated table like DAX below.

 

New table= CALCULATETABLE('XXX', 'XXX'[XID]= 'Y'[YID], IF(ISBALNK('ZZ'[DateField]), TODAY(), 'ZZ'[DateField] ), IF(ISBALNK('AnotherDateField'[OtherDateField]), '2100-01-01', 'AnotherDateField'[OtherDateField] ) )

 

Then you filter the table visual which display the new created table above using Top N filter of Visual level filter in Filter pane.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.