I am new to power bi. I am trying to create a report using dynamics 365 data using power query. I have a data like below table
I need to get the total count of phone calls made in first 7 days after the lead is created. Like below
Please help me with a solution
Go to Solution.
this is very easy to solve...
this should help you by generate a new calculated column
var leadCreated7d = Tabelle1[Lead Created on] + 7
IF(Tabelle1[Activity created date] <= leadCreated7d; 1; 0)
Just setting the value to sum.
View solution in original post
Hello @rainer1 ,
This works... Thanks a lot for your help😀
You are welcome 😁
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.