Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Identify the missing sections in a table

Here's the sample model that helps to identify the missing sections on my real time scenario. There is a table which has different sections - I am extracting only the July, Aug, Sep months of data t...
daXtreme's avatar
daXtreme
Solution Sage
3 years ago

Hi Anonymous 

 

The best and easiest way to do it is to... identify the missing pieces in Power Query (should not be hard and definitely easier than in DAX!) and create a table with them in there. Then import this table into Power BI together with others, the originals. If you do that, your DAX will not only be fast and SIMPLE but you'll be able to code against the model with ease 🙂 Trust me, I know what I'm saying.

 

If I get a bit of time, I'll play with this and write/generate the M code needed to achieve the above. But you should try to do it yourself as well 🙂 You'll then learn the power of M.

 

Cheers.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I appreciate your suggestions and the way you motivate daXtreme . Almost tried to complete by learning on my own with some partial output. Thank you for taking the time to provide a referral.