#daxhelp search results
Need some #daxhelp. I have Two dates in a fact table. From each of those dates need to lookup the corresponding fiscal year and perform operation. Let's say substract the fiscal year of the closed date from the fiscal year of the receipt date. Hope is not lookup
Anyone can help with the T-SQL variant of this dax: CALCULATETABLE ( FILTER ( ALL ( 'Date'[Date] ), AND ( 'Date'[Date] <= MAX ( 'Date'[Date] ), YEAR ( 'Date'[Date] ) = YEAR ( MAX ( 'Date'[Date] ) ) ) ) ) #sqlhelp #daxhelp
#DAXHelp I need a distinct count of values in column where value IS NOT X any ideas?
#DAXHelp SUMMARIZECOLUMNS not working in SSAS Tabular 2016, any suggestions? Thx
#DAXHelp #PowerBIHelp I thought you could set a variable as a table in an IF() statement. e.g. var vTable = IF( [Measure]=0, CALCULATETABLE(Table, FilterA), CALCULATETABLE(Table, FilterB)). I want to do this to pass as a filter predicate to another CALCULATE.
I've a fact, w/ bridge tables to dim tables to resolve 1:M. I copied user table because there's author & recipient. Wanted to easily slice w/ filters on either, so preferred over role play dimensions & inactive relationships. #DAXHelp
Need some #DAX help. Tried this 16 different ways and can't get it to work. Added a date, still can't go. community.powerbi.com/t5/Desktop/DAX… #daxhelp
#DAXHelp #PowerBIHelp I thought you could set a variable as a table in an IF() statement. e.g. var vTable = IF( [Measure]=0, CALCULATETABLE(Table, FilterA), CALCULATETABLE(Table, FilterB)). I want to do this to pass as a filter predicate to another CALCULATE.
Need some #daxhelp. I have Two dates in a fact table. From each of those dates need to lookup the corresponding fiscal year and perform operation. Let's say substract the fiscal year of the closed date from the fiscal year of the receipt date. Hope is not lookup
I've a fact, w/ bridge tables to dim tables to resolve 1:M. I copied user table because there's author & recipient. Wanted to easily slice w/ filters on either, so preferred over role play dimensions & inactive relationships. #DAXHelp
#DAXHelp SUMMARIZECOLUMNS not working in SSAS Tabular 2016, any suggestions? Thx
Anyone can help with the T-SQL variant of this dax: CALCULATETABLE ( FILTER ( ALL ( 'Date'[Date] ), AND ( 'Date'[Date] <= MAX ( 'Date'[Date] ), YEAR ( 'Date'[Date] ) = YEAR ( MAX ( 'Date'[Date] ) ) ) ) ) #sqlhelp #daxhelp
Need some #DAX help. Tried this 16 different ways and can't get it to work. Added a date, still can't go. community.powerbi.com/t5/Desktop/DAX… #daxhelp
Is there a way in DAX to select current year Jan2017 and then it returns all the records from then until previous year Jan2016 #DAXhelp #SQL
#DAXHelp I need a distinct count of values in column where value IS NOT X any ideas?
Something went wrong.
Something went wrong.
United States Trends
- 1. Seahawks 25K posts
- 2. Rams 18.4K posts
- 3. Giants 69.5K posts
- 4. Bills 141K posts
- 5. Bears 62.1K posts
- 6. Daboll 13.4K posts
- 7. 49ers 16.5K posts
- 8. Lions 55K posts
- 9. Jags 7,250 posts
- 10. Dart 27.4K posts
- 11. Caleb 51.2K posts
- 12. Texans 39.4K posts
- 13. Dolphins 34.3K posts
- 14. Commanders 42.6K posts
- 15. Josh Allen 17.2K posts
- 16. #OnePride 3,245 posts
- 17. Niners 3,786 posts
- 18. Browns 39.7K posts
- 19. Russell Wilson 4,195 posts
- 20. #RaiseHail 2,757 posts