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
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! ğŸ˜€