#daxhelp search results
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 #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
#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.
#DAXHelp I need a distinct count of values in column where value IS NOT X any ideas?
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
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
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 #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. Veterans Day 90.2K posts
- 2. Mainz Biomed N/A
- 3. United States Armed Forces N/A
- 4. Good Tuesday 31.1K posts
- 5. SoftBank 8,595 posts
- 6. #tuesdayvibe 1,841 posts
- 7. #Talus_Labs N/A
- 8. Vets 14.1K posts
- 9. Armistice Day 12.5K posts
- 10. #MYNZ 1,428 posts
- 11. Bond 62.6K posts
- 12. #ARMY 1,637 posts
- 13. #Gratitude 1,502 posts
- 14. World War 40.5K posts
- 15. Wike 9,787 posts
- 16. NextNRG Inc N/A
- 17. Window 55.1K posts
- 18. 600k Chinese 6,202 posts
- 19. $NBIS 7,399 posts
- 20. 600,000 Chinese 11.3K posts