How to sort months in power bi - Short Tutorial |Power BI interview Questions
#powerbi_training #powerbi
In today's Power BI Interview Question ,we take a look at How to sort months in Power BI. Although this is quite simple but its a very commonly asked interview question .This short tutorial helps answering this question .
Step 1: Create a numeric column called month_No
Step 2: Use the expression MONTH(Dim_Date(Full_Date)).
Step 3 :Now select the Month Column and go to "Sort by Column" option
Step4:Select the newly created column called Month_no
Step5 :Go to canvas and you will get the sorting based on Month
🔥🔥🔥Check out our other Power BI Tutorials Videos :🔥🔥🔥
👉1.SamePeriodLastYear with Example: • difference between parallelperiod and same...
👉2.How to Calculate Running Totals: • How to calculate running total in power bi
👉3.Duplicate Vs Reference : • power bi difference between duplicate and ...
👉4.Merge Vs Append: • power bi difference between merge and append
👉5.Calculate Function in DAX Power BI: • What is Calculate Function in Power BI DAX...
👉6.Filter Function in Power BI: • Filter Function in Power BI DAX
👉7.Row Vs Filter Context: • Row Context Vs Filter Context in Power BI
👉8.ALL DAX Function: • How to use ALL Dax Function in Power BI | ...
👉9.ALL Vs ALLSELECTED : • allselected dax|all vs allselected dax | p...
👉10.ALL Vs ALLSELECTED VS ALLEXCEPT : • All Vs AllSelected Vs AllExcept | Power BI...
👉11.ALL Vs REMOVEFILTERS : • ALL Vs REMOVEFILTERS Difference in Power B...
👉12.TOPN Dax Usage : • TOPN Dax | How to use topn dax in power bi...
👉13.Summarize Dax Function in Power BI: • summarize dax | How to use summarize in DA...
👉14.Summarize Vs Summarizecolumn : • summarize vs summarizecolumns | how to use...
👉15.Calendar Vs CalendarAuto : • Calendar Vs Calendar Auto Dax Function| Po...
👉16.How to create a date table in Power BI : • how to create a date table in power bi: st...
👉17.How to calculate Running total for date values in Power BI
• How to calculate Running total for date va...
👉18.How to calculate running total in power bi for non date values: • Running Total in Power BI for non date Val...
👉19.Usage of datediff in Power BI: • Power BI datediff dax Usage with Example| ...
👉20.Isblank() Vs Isempty : • Power BI ISBlank DAX Function with IF Cond...
🔥🔥Learn Power BI through our vlog and Free Videos:🔥🔥
https://powerbizone.com/category/arti...
❤️❤️Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Download the pbix file for practice:
https://drive.google.com/file/d/1hJri...