Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have different products sold on every day. I want to know in a particular month how many pieces of a particular product were sold.
The data is :
And the Output should be :
I request for the response as soon as possible. Please anyone help me
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
I created a calendar table with having month name column and month number column. This helps to create a monthly aggregated information.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
I created a calendar table with having month name column and month number column. This helps to create a monthly aggregated information.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Yes this is what I required. But I dont want blank spaces for the month which dont have sales. Instead it should be filled with "0". Can u please help me out on how to do this?
Hi,
Thank you for your message.
Please try to write measure (explicit measure) like below and put it into the visualization.
Please check the below measure and the attached file.
No of sales measure: =
SUM( Data[No of sales] ) + 0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
I'm not sure if I'm doing any mistake related to managing permissions. I'll send the screenshot of the relationships. Let me know where did i go wrong.
I'm a beginner to power bi. So I seek for a help.
Hi,
Please share your pbix file's link (onedrive or googledrive or dropbox...), and then I can try to have a look into it.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
I got the solution as expected. Thank you so much for your help
I have shared you the link of that pbix file Link. Hope a solution for my problem
Hi,
I do not have an access.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
I'm not aware of how to share pbix file directly here
Didnt get the desired output. the output i got:
@Simran-Fathima , Create a date table and join with your date and Month year there
Try a measure like sum(Table[No of sales]) +0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
49 | |
45 | |
20 | |
16 |