May 8, 2018
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.
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013