This is a short video on how to use TREATAS function in power bi when you have unrelated tables. Treatas function helps you to get the values from another table even though if there is no relationship between two tables.
I have used a very small data set so it is easy to follow.
Other Videos which you might be interested:
1. Summarize Columns : youtu.be/6nk2LG3s0Gk
2. Change the color of Selected Button : youtu.be/s-Vo3DjUCNo
3. Hide and Unhide Visuals to optimize space : youtu.be/QUcW8gudhLw
4. Earlier function : youtu.be/0TI6vqRevmk
5. Selected Measure or Calculated group : youtu.be/ygUrlWFKfYU
6. DatesMTD, DatesQTD, DatesSYTD : youtu.be/eG8wK8DYRSY
7. Targets & Trend : youtu.be/LKLKVzDqcEs
8. Blank, Isblank, Isnumber, Istext : youtu.be/H4LfuNOCX8c
9. Select Columns : youtu.be/HW6_t5T6pl4
10. Divide by Zero Error Handling : youtu.be/sSKkONo3upk
11. Mean , Median, Mode : youtu.be/4l1UUIkrZxg
12. Many to many relationship : youtu.be/94UDi2_NGXM
13. Count working days, exclude holidays : youtu.be/twpp-fAKcnU
14. Weekly Rolling average : youtu.be/UcB-Cz6v6Sw
15. Enable tabular editor : youtu.be/BZeAk65lAuY
16. Add Columns : youtu.be/QA0d3rEaUkc
17. Contains, Containsstring : youtu.be/LYyJqEbjz1g
18. Variance & Standard Deviation : youtu.be/HBjRgjFODNk
19. Row Number : youtu.be/vVuH_qgbku8
20. Summarize : youtu.be/rS8LLCT5JGs
- Power BI TREATAS function| Pass text as a parameter in pbi | get values from a disconnected table ( Download)
- How to use TREATAS Function in Power BI Desktop ( Download)
- DAX TREATAS function not showing the correct numbers Power BI ( Download)
- DAX | Power BI | Table Manipulation | VALUES and TREATAS Functions ( Download)
- DAX Function TREATAS in Power BI ( Download)
- TREATAS DAX in POWER BI #dax #powerbi #powerquery #dataanalytics ( Download)
- Using the SELECTEDVALUE function in DAX ( Download)
- DAX - TREATAS Functions ( Download)
- TREATAS DAX In Power BI - TAIK18 (6-25) Power BI ( Download)
- TREATAS function to handle missing relationship in the model - 45 (Power BI Training) ( Download)
- 128.How to use TreatAs DAX Function in Power BI || Telugu ( Download)
- Generateseries Function (DAX) - DAX Generateseries Function In Power BI Desktop | DAX Tutorials ( Download)
- Power BI GROUPBY function | group by in pbi | group by a category in pbi ( Download)
- DAX - All Trigonometric Function in Power BI ( Download)
- Power BI - Treatas, When, Why and How. How to use TREATAS, What are the usage areas of TREATAS ( Download)
