Forum Discussion
How to pull the data for specific Column?
Excel file I want to pull the data for the two measures. For the first measure, I want to pull the data for the past month from the 0th Column. I created first measure1. And for the...
Measure1 = CALCULATE(sum('Projektprognos (2)'[Value]),'Projektprognos (2)'[Attribute]=0)
Measure2 = CALCULATE(sum('Projektprognos (2)'[Value]),'Projektprognos (2)'[Attribute]>0)
Thank you for the suggestion however measure2 I tried the same method however I cannot get these values in highlighted
Please state your calculation rules again. I am not clear which rule should be applied for attribute 0 versus the other ones.
I want pull always the data for 2022/05/23/(always from present date) the green highllighted from attribute 1 to 12. 2nd measure
Measure2 = CALCULATE(sum('Projektprognos (2)'[Value]),'Projektprognos (2)'[Period]=2022-05-23) However it is not working to pull the data for attribute 1 to 9 on specific period 2022-05-23