Hi Mynda
I need some assistance with Power BI, the free desktop version:
Please find the attached file with my data (which I will use to import as a query into Power BI).
I want to create a measure in Power BI based on the formula below which is based on the delivery date to show me Overdue in FY2023; Overdue in FY2024 and Future FY2024.
=IF([Delivery Date]<TODAY()-1,"Overdue in FY","Future FY")&IF(MONTH([Delivery Date])<7,YEAR([Delivery Date]),YEAR([Delivery Date])+1)
I then want to create the first graph (Clustered Column - Line Chart) in my PDF report but just cannot get this one right in the free version - the x-axis is my reporting dates i.e. week to week (Wednesdays and as and when required). I then want to create the other graphs as per the PDF report.
Please can you help.
Amien
Hi Amien,
Instead of a measure, have you tried adding a calculated column? Calculated column seems more appropriate to your scenario, as each result is different for every Delivery Date. In a calculated column, the formula is very close to the one you mentioned.
