📈Scenario Based POWER BI Interview Q & A Asked at

แชร์
ฝัง
  • เผยแพร่เมื่อ 27 พ.ย. 2024

ความคิดเห็น • 3

  • @krishnakantapanda6835
    @krishnakantapanda6835 7 หลายเดือนก่อน +4

    More efficient way to achieve the same output would be..
    Due date=
    Dateadd( Status[last modified date],
    30,
    Day
    )

  • @madhusudhanreddyt2838
    @madhusudhanreddyt2838 4 หลายเดือนก่อน

    Hi...
    I really don't understand how you have made such a simple question really confused and little lengthy..
    if you want to add Due Date column which is going to be 30 days ahead of the last modified date, you can use the DateAdd function
    =DateAdd(Status[Last Modified Date], 30, Day)
    if you want to implement the same functionality in power query editor, you can use the power query mscript
    add custom column and write the below code
    =Date.AddDays([Last Modification Date], 30)