Forum Discussion

ldwf's avatar
ldwf
Icon for Helper V rankHelper V
4 years ago

Help with Calculation

Hello, my PBI model is star schema.  In the fact table, I created two measures in PBI, Current Month Revenue and Prior Month Revenue.   The 'Current' Month and 'Prior' month are determined based on w...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
4 years ago

Hey ldwf ,

 

you have to create a measure that determines the difference, this is because calculated columns can not leverage measures.
After you have created the measure you can use KPI icons to show a symbol, the following article describe how this can be achieved: Conditional Formatting Using Icons In Power BI 🔶 - Excelerator BI

 

Hopefully, this provides what you are looking for. If not, create a pbix file that contains sample data but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to onedrive or dropbox and share the link.

 

Regards,

Tom

  • ldwf's avatar
    ldwf
    Icon for Helper V rankHelper V
    4 years ago

    Tom, I followed your suggestion and created a measure called 'Difference' that calculates the difference.  if the current month revenue is 0, I show 'N/A', and if the Prior Month Revenue doesn't exist, I show 'No data for prior month', otherwise I show the difference.   I created a sample report and this shows correctly.  However, I am getting back records that don't belong on the report, i.e, records which don't have information for the dates I select in the slicer.  Should I use a DAX formula with var function and filter on the date such that it is equal to the date in the slicer?