Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our RUclips channel 👉Please ping on WhatsApp wa.me/9916961234
This lecturer is simply amazing.. Bcz only by watching video on power Bi project I got a very good knowledge and these power Bi videos helped me a lot lot lot to crack an interview in one of the MNC's. Seriously these videos changed my life.. Thank you so much sir... I have seen many videos on power Bi but I usually never comment on it. Since these videos changed my life, I have to comment on this.. I really don't know what to say. Thank you so much Sir 😊
This video is incredibly helpful, and I greatly appreciate the thorough and clear explanation you provided. I truly enjoyed watching it, as it contains a wealth of valuable information. I highly recommend that every PowerBI developer who is currently job searching take the time to watch this video.
thanks for this valubale and informative video , this gentleman is not explaining only the project but he also giving us what is like to work with real time project is, again thank you very much...
Excellent explanation sir. Very crystal clear speaking as well as concepts. Very detailed and clear as well. I am completely a new user for Power BI desktop application, but by doing all the hands-on till now in this video i am feeling very much confident in BI domain with Power BI tool as well. You're really doing great work here by sharing your expertise so clearly with the world. Keep it up sir 🙏 Kudos. Thank you so much once again.
Thank you so much sir for such detail explanation . 👍 Kudos to your efforts. Pls post more videos of such projects of multiple domain which is highly appreciable..🙏
Amazing, thank you so much. Can you please make a video on list of skills required for Power BI / Data analyst profile? It will be helpful for employees who are migrating from other domain.
Great Video KSR. I am recommending this channel to many now. Also, I expect a few more reports based on Procurement analysis, Humar resources Analysis too. Please support!
i just saw the video and realised that i missed a opportunity to have classes with you, recently 2 days before i have paid to some other institution which is located in Hyderabad.....
TO ALL WITH THE 'DATE ISSUE' I've founded the solution: Go to the 'Transform Sample File' table in the power query editor. Then, replace the dot (.) by a slash (/) in the date column. After that you will see the Sales table with the date column with the correct type.
It looks like the change from Product table to ProductDetails might be affecting your calculation. Here's how to troubleshoot: Check Table Names: Ensure you’re referencing the correct table (ProductDetails) in your TOTAL REVENUE calculation. Adjust Columns: If column names changed too (like Product[Price] to ProductDetails[Price]), update your formula to match the new structure
Thank you sir, I have question since the date format of united state different from Indian when I load sales table in to power query editor it gave some error. what should I do to handle this error.
Handling Different Date Formats in Power Query Understanding the Issue: When importing data from different regions, especially those with different date formats (like the US and India), Power Query might encounter errors if it's unable to correctly recognize the format. Solution: Identify the Format: Use the Text.Format function to inspect the first few rows and determine the US date format. For example, if the US format is "MM/DD/YYYY," you can use: Code snippet Table.TransformColumns(YourTable, {"DateColumn"}, each Text.Format(_, "MM/DD/YYYY")) Use code with caution. Convert to a Common Format: Once you've identified the US format, convert it to a common format that both regions can understand. This is often done using the ISO 8601 standard format, "YYYY-MM-DD". Code snippet Table.TransformColumns(YourTable, {"DateColumn"}, each DateTime.FromText(_, "MM/DD/YYYY", "en-US")) Use code with caution. Handle Errors: If there are other date formats present, consider using a try...otherwise expression to handle potential errors: Code snippet Table.TransformColumns(YourTable, {"DateColumn"}, each try DateTime.FromText(_, "MM/DD/YYYY", "en-US") otherwise null) Use code with caution. Example: Assuming your date column is named "Date" and contains US dates in the "MM/DD/YYYY" format, you could use the following code: Code snippet let Source = Csv.Document(File.Contents("YourFile.csv"), [Delimiter=","]), #"Changed Type" = Table.TransformColumns(Source, {"Date"}, each DateTime.FromText(_, "MM/DD/YYYY", "en-US")), #"Filtered Rows" = Table.SelectRows(#"Changed Type", each not IsError([Date])) in #"Filtered Rows"
Hi Raghav, 👉Please ping us on WhatsApp wa.me/919916961234 for more details and clarification drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB
Hi This vdo helpful I have question , So I use function year for get the return to Column year but the result i got 1447 for duplicate field as whole columns how to solve it to get Correct Year result , Thank you
Hi Werapat Malikhao! I’m glad you found the video helpful! The issue of getting unexpected values like 1447 when using the YEAR function usually indicates that the data type of the column you are referencing may not be in the correct date format or that there are duplicate values causing confusion. Here’s how to troubleshoot: Check Data Type: Ensure that the column you are using with the YEAR function is formatted as a Date type. You can do this in the Power Query Editor or by selecting the column and checking the data type in the column tools. Remove Duplicates: If there are duplicate values, consider using a summarization or grouping technique to ensure you are not inadvertently pulling in multiple records. You can use functions like GROUPBY or SUMMARIZE to aggregate your data. Use DISTINCT: If you're looking to get unique years, you can modify your measure to use the DISTINCT function. For example: DAX Copy code UniqueYears = DISTINCT(YEAR(Table[YourDateColumn])) If you continue to have issues, feel free to share more details about your data structure, and I can help further!
you cna check the dats set and other information availabile in description try once, if not able to find get back to us. if you’re enjoying the content, consider subscribing to the channel for more updates. It really helps motivate us to keep creating helpful videos for you!
Data Architects, Clients, PMs will create doc. drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing Please download the data from here
Thanks for sharing.. I have a query.. In Data Modelling we've here Snowflake Schema.. Is it good to merge Category, Subcategory into the products table and then build the relationship between product table and slaes fact table.. By doing this we can achieve Star schema..
@@KSRDatavizon I mean as the new data gets added and refreshed according to schedule, date also gets changed in the date master table? I hope it does, right?
Sir when i was bringing sales table in power bi the date column is showing blank wht should i do. I followed you as u said steps i did but date column is blank
consider these quick troubleshooting points: Data Format: Ensure that the date column in your source data has the correct date format. Power BI might not recognize dates if they're not in a recognizable format. Data Type: Check if the date column in Power BI is recognized as a date data type. You can change the data type by selecting the column and using the "Modeling" tab. Data Load: Verify if the data is properly loaded during the data refresh process. Check for any data loading errors in the Power Query Editor. Column Mapping: In Power Query Editor, make sure the date column is mapped correctly from your source data to the Power BI dataset. Locale Settings: Sometimes, date formatting issues occur due to different locale settings. Check if your report's locale settings align with your data's date format. Transformations: Ensure that there are no data transformations that inadvertently affect the date column's values. Null Values: Check if there are any null values in the date column of your data source. Power BI might show blank dates if it encounters null values. Time Zone: If your data involves time zones, ensure they are handled correctly during data transformation. Data Preview: In Power Query Editor, preview the data to confirm that the date column is being loaded correctly. Data Refresh: After making any changes, refresh the data in Power BI to see if the issue is resolved. If the date column is still showing as blank after checking these points, you might need to provide more specific details about your data and the steps you've taken so that a more targeted solution can be provided.
Hi , ur classes r good , but i'm enable to make the relationship between Sales & Product ( Total Revenue) can u please explain it how it works . In Edit Relationship , i'm getting Cross Filter Direction -Both Option & in Cardinality i'm getting Many to many , r else the ok Option is not visible for single - in Cross Filter Direction .
Guess you are missing some part of cleaning process. drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing please try again, u can take data from here
The issue you're facing with month number 1 being converted to December instead of January is likely due to a mismatch in the date format settings or the specific function you're using. Here are some common causes and solutions: 1. Incorrect Date Format: Check your regional settings: Ensure that your system's regional settings are configured to use the correct date format (e.g., Month, Day, Year). If the format is incorrect, it can lead to unexpected results when converting month numbers. Use the correct format code: When using functions like TEXT or DATEFORMAT, make sure you're using the correct format code for the desired month name (e.g., "MMMM" for full month names). 2. Function Misuse: Incorrect argument: Double-check that you're providing the correct arguments to the function you're using. For example, if you're using TEXT, make sure you're passing the month number as the first argument and the desired format code as the second argument. Function limitations: Some functions may have limitations or specific requirements regarding the input values. Ensure that you're using the function correctly and within its intended scope. 3. Data Type Issues: Ensure numeric input: The month number should be a numeric value. If it's stored as text or has leading zeros, it might not be recognized correctly. Convert to numeric: If necessary, use functions like VALUE or NUMBERVALUE to convert the month number to a numeric data type. Here are some examples of how to convert month numbers to month names in different programming languages and software: Excel: Excel =TEXT(A1, "MMMM") Use code with caution. Where A1 contains the month number. Python: Python import calendar month_number = 1 month_name = calendar.month_name[month_number] print(month_name) Use code with caution. JavaScript: JavaScript const monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"]; const monthNumber = 1; const monthName = monthNames[monthNumber - 1]; console.log(monthName); Use code with caution. By addressing these potential causes and following the appropriate methods, you should be able to successfully convert month numbers to month names without encountering the December issue. Sources and related content
Bro i've one doubt with-in DAX while using Month, Quarter these type of functions will get intellisense along with Query Field name, but why don't we select DateMaster[Date].Date i've observed that you are not using that (.Date). Any reason for this. Plz reply me. Thank You.
Can you Provide dataset for - sales(2104,2015,2016,2017). Got issue when it gets loaded in to Power Bi Desktop."" We couldn't parse the input provided as a Date value.""
I am getting error in date column in sales after 386 rows which says Date format error: We couldn't parse the input provided as a date value Details: 13.1.2016
Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our RUclips channel 👉Please ping on WhatsApp wa.me/9916961234
This lecturer is simply amazing.. Bcz only by watching video on power Bi project I got a very good knowledge and these power Bi videos helped me a lot lot lot to crack an interview in one of the MNC's. Seriously these videos changed my life.. Thank you so much sir... I have seen many videos on power Bi but I usually never comment on it. Since these videos changed my life, I have to comment on this.. I really don't know what to say. Thank you so much Sir 😊
Glad to hear that Adarsh. Congratulations :) Thanks so much for the feedback. Can you please review us on Google. Please do refer us in your network.
Adarsh Naik - Pls help me with power BI job.I have good knowledge but not getting job yet so far. Can you recommend
Elegantly teaches everything about endtoend project transformation by Santhosh sir by ksr team and great effort of our team mahesh sir
Thank you 😊
This video is incredibly helpful, and I greatly appreciate the thorough and clear explanation you provided. I truly enjoyed watching it, as it contains a wealth of valuable information. I highly recommend that every PowerBI developer who is currently job searching take the time to watch this video.
Gald you liked it.. this will motivate us to upload more.. thanks
really simply understand this session ..... your slang is clearly understand my level of english...thank you sir
You are most welcome
This is very simple and powerful practice to create End to End project, Thank you for very good Explanation
Glad it was helpful!
thanks for this valubale and informative video , this gentleman is not explaining only the project but he also giving us what is like to work with real time project is, again thank you very much...
So nice of you ! You are welcome! Please subscribe our channel, it motivates us
Sir, Very Very Knowledgeable Video. Thanks Allah Aap ko Dunya ma Khoos Rakhay.
Thank You so much
Sir ji Your Work Quality and Effort are SOOOOO High , Excellent , and Unbeatable.
Thank you Sir..!
So nice of you Shivam. Welcome :) Please do share in your network.
Sir it was a awesome your teaching style and and better understanding easy way
Thank You so much , Please subscribe our channel for regular updates.
Thank you so much sir ❤ for this amazing playlist. You have taught us the industry standards which nobody does
It's my pleasure
Good to see this video...how real-world challenge occurs
You're welcome, please subscribe our channel for regular updates
Excellent explanation sir. Very crystal clear speaking as well as concepts. Very detailed and clear as well. I am completely a new user for Power BI desktop application, but by doing all the hands-on till now in this video i am feeling very much confident in BI domain with Power BI tool as well. You're really doing great work here by sharing your expertise so clearly with the world. Keep it up sir 🙏 Kudos. Thank you so much once again.
you are welcome, please subscribe our channel for regular updates
i am very impressed with your project sir . Thnaku
You are most welcome
Amazing explained each and every
Thanks
Thank you so much sir for such detail explanation . 👍
Kudos to your efforts.
Pls post more videos of such projects of multiple domain which is highly appreciable..🙏
Keep watching
The way you explained was superb
Thanks a lot 😊
Excellent explanation. Thankyou !
You are welcome!
Thank you so much for making these videos, it helps us in a fantastic way 👍
Our pleasure!
Hi i m doing the project with you, more to see real time project in future
Nice to see this video!!
Glad you like it!
Thanks for complete lifecycle of power bi.
Most welcome
Very helpful video and waiting for more videos.
More to come! Keep Watching
Amazing explanation Sir❤️❤️
Hates off 🤲
Thank you so much, Please subscribe our channel for regular updates.
Amazing, thank you so much. Can you please make a video on list of skills required for Power BI / Data analyst profile? It will be helpful for employees who are migrating from other domain.
Yes I also would love to get this knowledge
Sure will upload asap
your explanation is very good
Thank you! I'm glad you found my explanation helpful. If you have any other questions, please don't hesitate to ask.
super thanx so much sir you explation is so good
Thanks and welcome
your explanation is good👌👌 , Thank u for sharing ... 👍
Welcome 😊
Awesome explanation
Glad you liked it
What a wonderful video sir,♥️
Thank you so much
Great Video KSR. I am recommending this channel to many now.
Also, I expect a few more reports based on Procurement analysis, Humar resources Analysis too.
Please support!
Thank you so much.
We will be uploading more videos
Simply super video👌 on how the transformations done and how to create date table and add columns.
Please make more videos on some complex data.
Sure Thanks for the suggestions. We will upload more projects
Good explanation . Thank you sir.
You are welcome
Excellent...Excellent.....
Many thanks
Amazing, Thank you
you are welcome
THANK YOU.EASILY UNDERSTANDABLE.
Thank you Srinivas for the feedback, please do share in your network. Next Video:
ruclips.net/video/ye2_fk1H2kQ/видео.html
Excellent explanation.... 👏👏👏
Thank you Deena, keep watching - do share in your network
👉Please ping on WhatsApp wa.me/919916961234 for more details regarding the course.
Fantastic… perfectly explained…great work 👍🏻👍🏻👍🏻
Glad you liked it
@@KSRDatavizon Part 3 ???
Sir it's Very Helpful Thankyou
Most welcome
i just saw the video and realised that i missed a opportunity to have classes with you, recently 2 days before i have paid to some other institution which is located in Hyderabad.....
No worries, we will make maximum videos to help you people.
LUV YOU BRO , THANK YOU ,
You're welcome!, Please subscribe our channel, it will motivates us
thankyou so much its great video
Awesome, super sir. Pls share the source file, it could be more helpful for practice.
Check description :)
finished watching
Thanks for watching
Thank you very much sir.
Most welcome
Useful videos 👏👏👏
Thank you 🙂
DESERVES A SUBSCRIBE
thank you so much
@@KSRDatavizon ,
Really it was very helpfulll
Well Explained 🙌
Glad you liked it!
TO ALL WITH THE 'DATE ISSUE' I've founded the solution:
Go to the 'Transform Sample File' table in the power query editor. Then, replace the dot (.) by a slash (/) in the date column. After that you will see the Sales table with the date column with the correct type.
it has 62% error with - format
Then, replace the dot (.) by a slash (/) in the date column
how, how do we do this?
Not working it with above process
Pls check your excel format.. This project was implemented live.. We dint get any issues
I have a query…how to check for duplicates in the dimension table when we have large number of records. Pls help me with this query
in power query editor it is straight forward to remove duplicates
nicely explained, can u share the same data for practice
Yes, sure, please subscribe our channel
hi thank you for the tutorial but I have errors when loading the sales data , kindly assist -please
Really Super, very clear explanation awesome sir, could you please share Business/function requirement document, that would really help full for us.
Thanks. All documents is uploaded and provided link in the description
Thank you Sir
Sir, please make a video on how to make transition from Power BI Developer to Data analyst and differences
Sure. We will upload ASAP
17:13 can we call this snowflake schema? Your foreign keys where having text data type. Foreign key data type should be whole number right?
Not necessarily that id should be number .. yes it's snowflake
This video really helpful for the beginners. Can you please how to down the CSV data???
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please download here for all datasets
Thanks
Welcome, please subscribe Our channel
❤TQ ❤🎉
Thank you for your support!
What data modelling we created
Is it star schema or snow flake schema
its star schema
@@KSRDatavizon but its connected two fact table...so i got confused?
@@KSRDatavizoncategory table subcategory tables are intervonnected
17:21
Sir Waiting for next part 3
Very soon
Could you please also upload SQL DBrelated videos which helps for Power bi
Thanks for suggestions. We will upload asap
In previous video there was product table now there is productdetails table and also when I am calculating total revenue it is not runing
It looks like the change from Product table to ProductDetails might be affecting your calculation. Here's how to troubleshoot:
Check Table Names: Ensure you’re referencing the correct table (ProductDetails) in your TOTAL REVENUE calculation.
Adjust Columns: If column names changed too (like Product[Price] to ProductDetails[Price]), update your formula to match the new structure
I stucked at a related function for calculating Total Revenue please any hint you can give me really appreciated
Before using related function.. make you have connected the tables.. there should be relationship between tables
Thank you sir, I have question since the date format of united state different from Indian when I load sales table in to power query editor it gave some error. what should I do to handle this error.
Handling Different Date Formats in Power Query
Understanding the Issue:
When importing data from different regions, especially those with different date formats (like the US and India), Power Query might encounter errors if it's unable to correctly recognize the format.
Solution:
Identify the Format:
Use the Text.Format function to inspect the first few rows and determine the US date format. For example, if the US format is "MM/DD/YYYY," you can use:
Code snippet
Table.TransformColumns(YourTable, {"DateColumn"}, each Text.Format(_, "MM/DD/YYYY"))
Use code with caution.
Convert to a Common Format:
Once you've identified the US format, convert it to a common format that both regions can understand. This is often done using the ISO 8601 standard format, "YYYY-MM-DD".
Code snippet
Table.TransformColumns(YourTable, {"DateColumn"}, each DateTime.FromText(_, "MM/DD/YYYY", "en-US"))
Use code with caution.
Handle Errors:
If there are other date formats present, consider using a try...otherwise expression to handle potential errors:
Code snippet
Table.TransformColumns(YourTable, {"DateColumn"}, each try DateTime.FromText(_, "MM/DD/YYYY", "en-US") otherwise null)
Use code with caution.
Example:
Assuming your date column is named "Date" and contains US dates in the "MM/DD/YYYY" format, you could use the following code:
Code snippet
let
Source = Csv.Document(File.Contents("YourFile.csv"), [Delimiter=","]),
#"Changed Type" = Table.TransformColumns(Source, {"Date"}, each DateTime.FromText(_, "MM/DD/YYYY", "en-US")),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each not IsError([Date]))
in
#"Filtered Rows"
Pls tell me what's the product
Can you please upload the same data set
Hi Raghav, 👉Please ping us on WhatsApp wa.me/919916961234 for more details and clarification drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB
Hi sir/madam I want know how to use existing template to power bi dashboard please make one video
Thanks for suggestions. We will upload asap
Hi This vdo helpful I have question , So I use function year for get the return to Column year but the result i got 1447 for duplicate field as whole columns how to solve it to get Correct Year result , Thank you
Hi Werapat Malikhao! I’m glad you found the video helpful! The issue of getting unexpected values like 1447 when using the YEAR function usually indicates that the data type of the column you are referencing may not be in the correct date format or that there are duplicate values causing confusion.
Here’s how to troubleshoot:
Check Data Type: Ensure that the column you are using with the YEAR function is formatted as a Date type. You can do this in the Power Query Editor or by selecting the column and checking the data type in the column tools.
Remove Duplicates: If there are duplicate values, consider using a summarization or grouping technique to ensure you are not inadvertently pulling in multiple records. You can use functions like GROUPBY or SUMMARIZE to aggregate your data.
Use DISTINCT: If you're looking to get unique years, you can modify your measure to use the DISTINCT function. For example:
DAX
Copy code
UniqueYears = DISTINCT(YEAR(Table[YourDateColumn]))
If you continue to have issues, feel free to share more details about your data structure, and I can help further!
In this video what type of modelling did you create?
snowflake
Sir how can i get the requirement tables in part 1 do to it as partical
you cna check the dats set and other information availabile in description try once, if not able to find get back to us. if you’re enjoying the content, consider subscribing to the channel for more updates. It really helps motivate us to keep creating helpful videos for you!
who creates this BRD/FRD document? and how to download CSV files from the Github link as provided?
Data Architects, Clients, PMs will create doc.
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please download the data from here
How do i get the Product table?
Thank you so much for your comment, Please like, share and subscribe our channel for regular updates. it motivates us a lot
Wr we can take Data set for practice
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please get data from this path
Dears DateMaster come from where?
We need to create one.. by using calendar dax function
Thanks for sharing.. I have a query.. In Data Modelling we've here Snowflake Schema.. Is it good to merge Category, Subcategory into the products table and then build the relationship between product table and slaes fact table.. By doing this we can achieve Star schema..
Yes, good thought, we could have done that. thanks for your suggestions
Hi sir is it possible to create star schema when I have only one table which contains dimension columns and fact columns
Yes u can. U can create all dimension table for all categorical data
@@KSRDatavizon if it's possible plz make a video on this scenario sir.
Please add BRD/FRD also in that GitHub repository
All files is attached in GitHub and shared in description. Please refer and download
In the date master table, will the last date be automatically readjusted after 2018 sales information added to the folder?
yes thats the purpose of lastdate function
@@KSRDatavizon I mean as the new data gets added and refreshed according to schedule, date also gets changed in the date master table? I hope it does, right?
Sir when i was bringing sales table in power bi the date column is showing blank wht should i do. I followed you as u said steps i did but date column is blank
consider these quick troubleshooting points:
Data Format: Ensure that the date column in your source data has the correct date format. Power BI might not recognize dates if they're not in a recognizable format.
Data Type: Check if the date column in Power BI is recognized as a date data type. You can change the data type by selecting the column and using the "Modeling" tab.
Data Load: Verify if the data is properly loaded during the data refresh process. Check for any data loading errors in the Power Query Editor.
Column Mapping: In Power Query Editor, make sure the date column is mapped correctly from your source data to the Power BI dataset.
Locale Settings: Sometimes, date formatting issues occur due to different locale settings. Check if your report's locale settings align with your data's date format.
Transformations: Ensure that there are no data transformations that inadvertently affect the date column's values.
Null Values: Check if there are any null values in the date column of your data source. Power BI might show blank dates if it encounters null values.
Time Zone: If your data involves time zones, ensure they are handled correctly during data transformation.
Data Preview: In Power Query Editor, preview the data to confirm that the date column is being loaded correctly.
Data Refresh: After making any changes, refresh the data in Power BI to see if the issue is resolved.
If the date column is still showing as blank after checking these points, you might need to provide more specific details about your data and the steps you've taken so that a more targeted solution can be provided.
In total revenu colum can we sumx() function ?
Yes you can. U can write in many ways
Hi Sir, Good Morning. While loading a sales report date column is blank. Pls guide me how to fix it.
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please try from this datasets
Sir ene to end power bi 4videos are hidden... not showing.once update sir please
We have only 4 videos in End to End Playlist. We will create more Projects
What is work of power bi tester?
Will validate all fonts, filter checks, requirement fulfillment check, smoke testing, data validation
how do we identify fact and dimension table?
U will have one id per row (easiest way to identity Dim table)
@@KSRDatavizon In this video what type of modelling did you create?
Hi , ur classes r good , but i'm enable to make the relationship between Sales & Product ( Total Revenue) can u please explain it how it works . In Edit Relationship , i'm getting Cross Filter Direction -Both Option & in Cardinality i'm getting Many to many , r else the ok Option is not visible for single - in Cross Filter Direction .
Guess you are missing some part of cleaning process.
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
please try again, u can take data from here
Here the type of schema we have used is Snowflake... right?
Can someone please confirm this.
Yes Snowflake Schema
Hi sir, converting the month number to the month name is giving the wrong answer. for 1 it is showing December. what could be the problem.
The issue you're facing with month number 1 being converted to December instead of January is likely due to a mismatch in the date format settings or the specific function you're using. Here are some common causes and solutions:
1. Incorrect Date Format:
Check your regional settings: Ensure that your system's regional settings are configured to use the correct date format (e.g., Month, Day, Year). If the format is incorrect, it can lead to unexpected results when converting month numbers.
Use the correct format code: When using functions like TEXT or DATEFORMAT, make sure you're using the correct format code for the desired month name (e.g., "MMMM" for full month names).
2. Function Misuse:
Incorrect argument: Double-check that you're providing the correct arguments to the function you're using. For example, if you're using TEXT, make sure you're passing the month number as the first argument and the desired format code as the second argument.
Function limitations: Some functions may have limitations or specific requirements regarding the input values. Ensure that you're using the function correctly and within its intended scope.
3. Data Type Issues:
Ensure numeric input: The month number should be a numeric value. If it's stored as text or has leading zeros, it might not be recognized correctly.
Convert to numeric: If necessary, use functions like VALUE or NUMBERVALUE to convert the month number to a numeric data type.
Here are some examples of how to convert month numbers to month names in different programming languages and software:
Excel:
Excel
=TEXT(A1, "MMMM")
Use code with caution.
Where A1 contains the month number.
Python:
Python
import calendar
month_number = 1
month_name = calendar.month_name[month_number]
print(month_name)
Use code with caution.
JavaScript:
JavaScript
const monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
const monthNumber
= 1;
const monthName = monthNames[monthNumber - 1];
console.log(monthName);
Use code with caution.
By addressing these potential causes and following the appropriate methods, you should be able to successfully convert month numbers to month names without encountering the December issue.
Sources and related content
Hi
why my sales information is not showing 100% 0% &0% rule but showing unexpected error ocuures for all coloumn
we dint get ur issue.. pls email your doubt with snapshots santosh_j@ksrconsultantservices.com
Bro i've one doubt with-in DAX while using Month, Quarter these type of functions will get intellisense along with Query Field name, but why don't we select DateMaster[Date].Date i've observed that you are not using that (.Date). Any reason for this. Plz reply me.
Thank You.
you can directly use .date functions. since we are creating date master we have used dax. we can use either way
Not able to download CSV files from your dataset
Please give me some solution to this....
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please download from here
Sir how can I get this dataset and BRD to practice .. thanks ?
We have added the dataset path in the description
sir the sales data is corrupted could u please resolve it.
let me chekc with my team.
Hi, date column in Sales table shows error 62% in power query? how to solve it?
drive.google.com/drive/folders/1pzx9OLvUJVF-Lcn07zSskY9GskX90hlc?usp=sharing
please take data from here
@@KSRDatavizonSir can you please approve the access request
Can you Provide dataset for - sales(2104,2015,2016,2017). Got issue when it gets loaded in to Power Bi Desktop."" We couldn't parse the input provided as a Date value.""
all files is tested and implemented using same files. Can you please check once excel version?
I am getting error in date column in sales after 386 rows which says Date format error: We couldn't parse the input provided as a date value
Details:
13.1.2016
pls get data from here and try
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
pls upload the data for practice
Hi Mam, its available in description
how to clear error in date coulmn in sales tables .it shows 62% error
Hi Monika, 👉Please ping us on WhatsApp wa.me/919916961234 to have a word with our trainer
Hi can u attach the FRD docs..
All files are uploaded to GitHub provided in description. Please refer and download.
We cnt download CSV files
Please try downloading here
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing