Forum Discussion
TDisco
Helper I
4 years agoFilter date ranges based on text filter value
Having an issue building a Filter dropdown with ‘names’ that aggregate dates. I get a feeling it’s a Power BI concept I’m not grasping. Have search many solutions for many days. This is what I curren...
- 4 years ago
I had a relationship link from the Date Selector to the Date Table. Removing that made all this work.
TDisco
Helper I
4 years agoA simpler recap. I have a filter that has words. I have a measure column, that based on the word selcted, runs one of 3 measures. The measures contain a formula that matches the a SUM value of the word. All these measures return the correct values (I can prove that by putting in a stand alone table) While I can get Current and Previous month to return a correct value, I'm not able to return a rolling 3-month count. (this DAX works and is proven in a table).... Any reason it would work in a table, but not in filtered measure? - Thanks (edits - clarity)