Thanks for showing the logical way of building the filter table to use in CALCULATE. The following code also produces the same result. The performance side is not checked. IF( [Sales Amount], CALCULATE( [Sales PY], VALUES(Sales[StoreKey]) ) )
@darioprskalo5569
2 жыл бұрын
Thank you Alberto. Excellent explanation 👌
@zeisslaimen1
3 жыл бұрын
very enjoyable to watch. Thanks Alberto.
@shiprasharan8298
3 жыл бұрын
Hello Alberto, Thank you for the video. I had one small doubt. Could you please explain why does @14:45 Column "Sales PY lkl" has different values from "Sales PY" for few of the dates after 06/05/2018 If my understanding is correct it shall display same value as " Sales PY" if we have any not null value for sales amount in current year. Please let me know if my understanding is incorrect. Regards, Shipra
@williamsantos9462
3 жыл бұрын
In 14:40 when getting rid of store filter I’m not sure if the measure was computing previous year correctly. Am I wrong?
@TheBruciaculo
3 жыл бұрын
Hello Alberto, Thank You for these series! Is Data Model / Database you use (I can see it's Contoso, but customized with e.g. more recent sales dates?) available for download anywhere? I'd love to follow along! Keep up the amazing work! Cheers
@SQLBI
3 жыл бұрын
We created a new version of sample databases based on Contoso as part of the training material for Mastering Tabular - the training includes several versions of the SQL database ranging from 10,000 orders to 10,000,000 orders (hundreds of GB): www.sqlbi.com/p/mastering-tabular-video-course/ You can download the sample file used for this video here: www.sqlbi.com/tv/checking-boolean-conditions-while-creating-a-like-fo-like-comparison-in-dax-unplugged/
Пікірлер: 7