Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I thought this would be much easier than it is turning out to be, but I have a Calendar table which I filter for dates. I have a measure setup to return how many calendar days are selected (e.g. 302 calendars on a Card). How can I reference that current measure value of 302 inside a DAX statement to generate a new data series?
In this example, I want to generate a series/table with 1 to 302, so I can add columns, etc, afterwards.
E.g.
newSeries = GENERATESERIES ( 0, CurrentMeasureValue, 1 )
Solved! Go to Solution.
Hi @mmack ,
That will not working. The content of the table will not be changed by the measure unless it is a temporary table generated in the formula.
Table and column created by measure will not change once they are created but measure will.
Best Regards,
Jay
Hi @mmack ,
That will not working. The content of the table will not be changed by the measure unless it is a temporary table generated in the formula.
Table and column created by measure will not change once they are created but measure will.
Best Regards,
Jay
Hi:
You can if your measure has a numeric value and you want to get the total of the result. Here is an example:
It is close, but not quite. This is what I experience when I use that method.
Here is my code for zfcdates Date Table:
zfcdates = CALENDAR(TODAY()-365, TODAY()+365)
Here is my code for CalendarDays Measure:
CalendarDays =
VAR FirstDay = CALCULATE(
MIN('zfcdates'[Date]),
ALLSELECTED('zfcdates'[Date])
)
VAR LastDay = CALCULATE(
MAX('zfcdates'[Date]),
ALLSELECTED('zfcdates'[Date])
)
RETURN
DATEDIFF(FirstDay, LastDay, DAY)
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |