Hello, I'm a complete Power BI newbie and trying to get my head round some of the features and some simple functions. I've managed to set up initial data source table and run create some initial visualisations on the data in the table, but now I'd like to take next step and do some more analysis relating to dates.
In my initial table called "Live Campaign List" I have two date fields:
- Date Started Planning
- Date Sent to Current Position
I'm trying to create measures using the DATEDIFF function to calculate:
- Power bi date difference (in days or months) between the two columns
- Power bi date difference from today (again in days or months)
This is probably too advanced for me, given I can't master the basic functions, but ultimately I think it would be good to determine a categorisation of risk - Red/Amber/Green based on length of time difference (ie those with longer time gap and priority level of campaign).
I have tried to use a DAX calcuation as follows:
Date Difference Interval Measure = DATEDIFF('Live Campaigns List'[Date Started Planning], 'Live Campaigns List'[Date Sent to Current Position], Day)
but I get an error message saying that in the "Date Started Planning" a single value cannot be determined.
What am I doing wrong? How do I get the calculations to work?
Thanks in advance
Ed
