Forum Discussion

ss8551's avatar
ss8551
Icon for Helper II rankHelper II
3 years ago

How to calculate the date diff to calculate the date diff based on a value of one column

I have a table that I need to deteremine if a rep took a course on a date (post-trained) otherwise (pre-trained) so that I can compare performance. When I do this in Power BI I can find the date, h...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago
the row is coming from a direct query

Next time please mention this fact earlier.

 

you cannot implement column logic in Direct Query connections if the data does not come from the same row.

ss8551's avatar
ss8551
Icon for Helper II rankHelper II
3 years ago

so you do not have any suggestions on a resolution to my isssue?  I did mention in my very first post that this was a direct query.  I stated this since I knew that this could be an issue.  Is there any way to either pull this data into antother tab and/or copy the data so that it fills all rows of the column?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    You are right, I should have read your first post more attentively.  I do not think there is a  way to accomplish this in Power BI. This needs to be done at the data source.

    • ss8551's avatar
      ss8551
      Icon for Helper II rankHelper II
      3 years ago

      so i am using a direct query but, i also have other tabs.   Is it possible to pull this data into another tab of Power BI that is not a Direct Query and then accomplish the same?  I'm trying to use the data from the Direct Query to add to some additional data in Power BI that I have created using a Snowflake Connecton.  If I add a coulumn into one of my tabs can I pull this data into one of these tabs and fill the empty cells either in this column or another column with this same date (so for example date of 1/1/22 to today to be filled with the date the training completed date)?  so that I'm not trying to add it to a Direct Query directly but from a column i pulled in from a Direct Query  to a new column in My Power BI.

       

      Not sure if this works but looking for any way to get this to function.

       

      Thanks againd for your assistance.