Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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 😁
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.