Great Chandeep Sir, although i have prepared one solution which also solving the problem. Products with no Sales = SUMX( VALUES(Products[Product]), IF( [Total Sales]>0, BLANK(), 1 ) )
Great stuff, Chandeep! Initially I thought the missing product wasn’t an issue since they won’t have sales rev then I saw you got free product. This solution is awesome and I applied immediately with my dataset and it works. The only caveat is that I use calendar year as slicer but it shows blank. Not sure how to be rid of it
Hello, first of all thank you very much for bringing such valuable contents and helping us learn things efficiently. I am stuck with a specific problem on excel pq. I want to find out the trailing large number in a dataset of equity market say sensex. I want to find out if the value is largest of all its historical data or not. It must be trailing all historical data. If there are x number of dates, i want to find out if the particular data is largest or not from all its previous data. I would really appreciate your help on this. Hope i have put my doubt clearly. Thanks
Dear Chandeep, it is not clear why you are using the helper column "SalesPresent" and the SELECTEDVALUE clause. Can you please explain in detail what is their use here? I tried the Measure without the SELECTEDVALUE clause and it works, although the only difference is that on the Totals of the Pivot there appears an erroneous amount (while with the SELECTEDVALUE clause there is a blank as it should be).
Can any one help how to write a dax code for calculating for example sales from last month up to date (ex: from 01-06-2022 to today of last month i.e 05-06-2022)...pls help me
You need to learn how to create calendar tables in power query. Here are a couple of TH-cam videos to get you started. Good luck! th-cam.com/video/Q_EqrlZAgXI/w-d-xo.html th-cam.com/video/YL7H1Rqckb0/w-d-xo.html
Great Chandeep Sir,
although i have prepared one solution which also solving the problem.
Products with no Sales =
SUMX(
VALUES(Products[Product]),
IF(
[Total Sales]>0,
BLANK(),
1
)
)
Great stuff, Chandeep! Initially I thought the missing product wasn’t an issue since they won’t have sales rev then I saw you got free product. This solution is awesome and I applied immediately with my dataset and it works. The only caveat is that I use calendar year as slicer but it shows blank. Not sure how to be rid of it
Great Chandeep! A problem similar to this one came up on my dataset, and I think this solution might fit what I need
You are just amazing...can you please explain why you used eomonth in salespresent column...I got bit confused in that part
Thanks for the video. Please could I know how to get the unsold products detail, eg. product ID and product name etc?
Hello, first of all thank you very much for bringing such valuable contents and helping us learn things efficiently.
I am stuck with a specific problem on excel pq. I want to find out the trailing large number in a dataset of equity market say sensex. I want to find out if the value is largest of all its historical data or not. It must be trailing all historical data.
If there are x number of dates, i want to find out if the particular data is largest or not from all its previous data.
I would really appreciate your help on this.
Hope i have put my doubt clearly.
Thanks
Goodly nice upload. Please I have a problem trying to solve a DAX calculation, how can I communicate with you?
Your videos are great, and I have learned from them too. My only request for you is you could slower, please
Dear Chandeep, it is not clear why you are using the helper column "SalesPresent" and the SELECTEDVALUE clause. Can you please explain in detail what is their use here? I tried the Measure without the SELECTEDVALUE clause and it works, although the only difference is that on the Totals of the Pivot there appears an erroneous amount (while with the SELECTEDVALUE clause there is a blank as it should be).
Finished watching
Can any one help how to write a dax code for calculating for example sales from last month up to date (ex: from 01-06-2022 to today of last month i.e 05-06-2022)...pls help me
You need to learn how to create calendar tables in power query. Here are a couple of TH-cam videos to get you started. Good luck!
th-cam.com/video/Q_EqrlZAgXI/w-d-xo.html
th-cam.com/video/YL7H1Rqckb0/w-d-xo.html
U r Awsm Sir.
Thank you!
Great
Thank you!