My company recently engaged with PBI, however IT department isn’t sharing Data Tables nor Relationships with users that are supposed to develop some report (dataset built from SAP BW which is connected to my PBIX from PBI connection).
I’m trying to build some basic insights but struggling more than expected (can’t access Data Tables…):
Total Revenue (Monthly average rate) was created by IT. Can’t see the code.
I created these measures:
Sales Yearly Act:
CALCULATE( 'SPP CS reallocation'[Total Revenue (Monthly average rate)], DATESYTD('SPP CS reallocation'[Posting date]) )
Which is actually acting as
Cumulative Act Sales:
CALCULATE( [Total Revenue (Monthly average rate)], FILTER(ALLSELECTED('SPP CS reallocation'[Posting date]), 'SPP CS reallocation'[Posting date] <= MAX('SPP CS reallocation'[Posting date]) ) )
Last, I wanted to compare vs
Sales Yearly Act PY:
CALCULATE( [Sales Yearly Act], ALL('Calendar'[Date]), SAMEPERIODLASTYEAR('Calendar'[Date]) )
Problem is Sales Yearly acting like cumulative, and PY Act Sales not showing up since I have report filtering 2019. If I take out the report filter I get PY Sales but won’t work in a chart.
As to the dates, I have tried the same using [Posting date] and the outcame was the same, was just trying out with [Calendar(date)]
Thanks for helping this newbie in need. Cheers!