Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
A table of my model has the next columns:
I want to create a new table where I have the actives items of my model for each day, I mean, the next columns:
I think I can create this new table with the function ADDCOLUMNS() or SUMMARIZE(), but I haven't got it.
Thans in advance.
I'm not exactly clear on what you are trying to do, nor why you need a new table to show this data vs just a measure that will calculate it in a visual.
Can you show a sample of your current data, and a sample of the expected output?
If you are sure you need a new table, see this article, and note that SUMMARIZE and ADDCOLUMNS should generally be replaced with SUMMARIZECOLUMNS.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting