Forum Discussion

tchooper7's avatar
tchooper7
Frequent Visitor
4 years ago

PowerBI - Choosing a relative field between 2 dates

I need to lookup a value and combine it in a another table in Power BI   Table 1:   Effective Start Date eg 1 July 2021 Effective End Date (this could be null as the end date may not have occurr...
Need Help
tchooper7's avatar
tchooper7
Frequent Visitor
4 years ago

Thank you for your assistance - in the Transform Data area the table is correct and the table has 7.4M rows - when apply the changes the table is created 11M rows - so am trying to work out what is happening there - would you have any thoughts please

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi tchooper7 ,

     

    This is strange. Because I added {0} in the formula, it will return for each row the first name that satisfies the condition. So it should not increase the number of rows. Does the result of those added duplicate rows make any difference?

     

     

    Best Regards,
    Winniz

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi tchooper7 ,

     

    Has your problem been solved? If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.


    Best Regards,
    Winniz