Forum Discussion
Solved
Create Table, or Measure for Current Price by Dates
Hello, I have a forcasting formula we built in Power Bi and it is working great for calculating the number of units expected to be sold, both in historical and future dates. Where I am having iss...
My Power BI gut says, what you are trying to do can be more efficently done with proper joining, or some code magic... but here's what you need for now. Hope it works!
Table 2 = CROSSJOIN('Date Table', 'Item Table')
Hi LanceTDL,
If you want to expand table records with a specific category, you can try to use CROSSJOIN functions and it will return a repeating table that includes records from two parameter tables.
Power BI DAX #1: The Magic of CROSSJOIN | by Michael Olafusi | Medium
Regards,
Xiaoxin Sheng