Forum Discussion

M-Beans's avatar
M-Beans
Regular Visitor
2 years ago
Solved

KPI Card - Help with Visual

I am trying to display a KPI card that compares the Year to Date Actual Revenue versus Year to Date Budget Revenue. I  have a column for Actuals that is populated each month and is currently populat...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi M-Beans 

     

    Download PBIX file with the example below

     

    Create a table with this DAX

     

     

    Dates_ = DATESBETWEEN('Dates'[Date], MIN('DataTable'[Date]), EOMONTH(TODAY(),-1))

     

     

    Use the date column in that table as the Trend Axis for the KPI.

     

     

    You will need also need a Date Table and all 3 tables need to be related by the Date field.

     

    Regards

     

    Phil

     

PhilipTreacy's avatar
PhilipTreacy
Super User
2 years ago

Hi M-Beans 

 

Download PBIX file with the example below

 

Create a table with this DAX

 

 

Dates_ = DATESBETWEEN('Dates'[Date], MIN('DataTable'[Date]), EOMONTH(TODAY(),-1))

 

 

Use the date column in that table as the Trend Axis for the KPI.

 

 

You will need also need a Date Table and all 3 tables need to be related by the Date field.

 

Regards

 

Phil