Power BI Modeling Tip Snapshot Table or DAX Measures

I often get this question: “Is it better that I create this calculation as a snapshot table in Power Query (or T-SQL, or the data source), or write DAX measures for it?” If you ever had a scenario of creating a report of snapshots, you know what I mean. “Should I have a table for inventory stock on hand values for each day, or should I calculate those values on the fly?”. Answering this question is an important Power BI modeling step. In this video, I’ll answer that question.
Read my blog article on this subject here with links to study more:https://radacad.com/power-bi-modeling...


*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

RADACAD courses: https://learn.radacad.com

Become an academy member: https://learn.radacad.com/academy/

*******************

********
CONNECT with US!
********

-- Twitter: radacad_com
-- Twitter: rad_reza
-- Twitter: leila_etaati
-- Facebook: radacad
-- LinkedIn: leila-etaati-b0304636
-- LinkedIn: rezarad
-- LinkedIn: 6393399
-- https://radacad.com

********

• #science_technology
• #power_bi
• #dax
• #data_modeling
• #modeling
• #power_bi_from_rookie_to_rock_star
• #dimensional_modeling