Forum Discussion
Help with Calculation
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
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?