Stelian, would you be able to transition the total sales line to a forecasted sales line?
@matthiasg.4941Ай бұрын
Hi there, I could not spot the sales target in the access data set you provide. Also I had to calculate the date table. It is a good exercise but I cannot advance as fast as I hoped. But thank you very much for your fantastic tutorials.
@MMS-PowerBI29 күн бұрын
First of all thank you for watching the tutorial. The dataset is something I created a while ago and it did not have a target table, but I believed that is a very good way of using the "Enter data" feature. As for the date table, if you need a comprehensive one, you can find out how to get the code for the one I use here: kzbin.info/www/bejne/baLEepSsgKiUpas
@matthiasgiger187529 күн бұрын
@@MMS-PowerBII already discovered some of your fantastic tutorials also the one how to create a date table. Many thanks for sharing them ❤.
@SamFisher-x2y16 күн бұрын
Hi Stelian, your measures reference [Total Sales], can you show the DAX for it?
@MMS-PowerBI16 күн бұрын
When I have that measure name, I always use SUM([column to be added]), with no added filters. Otherwise, I change the measure name to describe what it does, just in case somebody else will work on the report in the future.