Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date Parameter Used in Calculations

Hi, I have a use case where I need to use a date field in calculations within a PowerBI workbook. The calculations work fine when I use a hard-coded field as the date, but I need this date to be user...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thanks Anonymous for the confirmation. I ended up getting something to work by creating a date table and then doing a crossjoin between my original data & the date table. Not the most performant solution, but luckily my data set is relatively small.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks Anonymous for the confirmation. I ended up getting something to work by creating a date table and then doing a crossjoin between my original data & the date table. Not the most performant solution, but luckily my data set is relatively small.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

Thanks for your feedback and sharing your solution here. Could you please mark your post as Answered? It will help the others in the community get the solution or insight easier if they face the same problem as yours. Thank you.

Best Regards