Forum Discussion

tdewitt274's avatar
tdewitt274
Frequent Visitor
2 years ago

DAX Rownumber() to act like SQL Row_Number() with Dynamic Date

Hello, everyone   First off, I'd like to admit that I'm not well versed in DAX.  So, there might be a simpler process.   I have a request to simulate the below SQL Server query using a dynamic da...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi tdewitt274 ,

Please provide some sample date and can you explain how these figures were calculated?

I need to know the formula to find the DAX for you.

Best Regards,
Dino Tao

  • tdewitt274's avatar
    tdewitt274
    Frequent Visitor
    2 years ago

    Hello, Dino

     

    These are just COUNT and SUM the "columns" section of the "Build visual" section.

     

     

    Thanks,

    Todd