All Questions
3 questions
0
votes
0
answers
25
views
Is there a DAX function that takes Year, Month, and Week Number as inputs and then return a Date corresponding to the inputs?
I have a Table which my weekly report fetches data from. The Table is updated every week, so the data are in form of Week 1, Week 2,..., Week 5. I have other date information such as Year, and Month, ...
- 11
-1
votes
1
answer
631
views
Relative Date Item in Power Pivot GETPIVOT DATA excel function
I am using a GETPIVOTDATA function in Excel to source data from a pivot table generated by a Power BI query (everything was originally only in excel, the file got too large, so i stored the main ...
- 23
0
votes
2
answers
5k
views
Power BI: DAX formula to find number of days between dates gives "an invalid numeric representation of a date value was encounted" error
I've just recently begun using Power BI and DAX for my new job, so if this is a super simple or stupid fix I apologize.
I'm trying to create a column (NumDays) that calculates the number of days ...
