Showing revenue at benchmark stores per date

DAX DAX Calculations
1

Thanks @Melissa to this, it was possible to create a revenue display in semantic stores. Unfortunately, this metric with a date does not work. Request for help

Sample pbx: https://drive.google.com/open?id=1L2b9YIReTt27xSTmoBU8NCzDAO8QsGxO

1
11381×813 95.1 KB
2
2450×698 6.88 KB

2

Hi @Harris,

Here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.
  • Provide as much context to a question as possible.
  • Include demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

You can check the forum guidelines here How To Use The Enterprise DNA Support Forum . Not adhering to it may sometimes cause delay in getting an answer.

.
Bringing in additional dimensions like Dates for example can impact your calculations, so always design your model first. Keep in mind what you want to showcase, what you need to do so and how you want to visualize it in your report BEFORE you start writing DAX. :wink:

Revenue Bench Store =
VAR myStore = VALUES( Store_Benchmarking[StoreID_Bench] )
VAR Result = CALCULATE( [Revenue Measure], ALLSELECTED(Sales), Sales[StoreID] IN myStore )
RETURN

Result
2 Likes