Forum Discussion

harshad_barge's avatar
harshad_barge
Icon for Helper I rankHelper I
6 years ago

Modifying DAX query to extract correct value

Hi all,  So I am essentially trying to have a column that is grouped by sum of payment. I want just the cumulative Pay when the payroll date is greater than or equal to the Calculation Date. The gro...
groupby
index
SUMMARIZE
Anonymous's avatar
Anonymous
Not applicable
6 years ago
If you are trying to add a calculated column to a table in the model, then please spare yourself pain and grief - USE POWER QUERY.

Best
D
harshad_barge's avatar
harshad_barge
Icon for Helper I rankHelper I
6 years ago

Is there any way I can use a DAX calculated table in power query?
If that would be the case, things would be much easier.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    No.

    • harshad_barge's avatar
      harshad_barge
      Icon for Helper I rankHelper I
      6 years ago

      Unfortunately as I had thought!
      Power BI is made quite good then! Because, if it would go back and forth, I would be in a mess! ğŸ˜€