Forum Discussion

smina's avatar
smina
Frequent Visitor
3 years ago

Fortnight DAX

Hi everyone,

 

I'm looking for a DAX to group dates into fortnights - Starting 10/07/2023 to 23/07/2023.

 

Thanks!

2 Replies

  • AnthonyGenovese's avatar
    AnthonyGenovese
    Icon for Resolver III rankResolver III
    3 years ago

    Can  you provide more details on what you are trying to do? You want to create a new measure? Table visual? Calculated Column?

    If this post was helpful, please kudos or accept the answer as a solution.
    ~ Anthony Genovese
    Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

  • smina's avatar
    smina
    Frequent Visitor
    3 years ago

    Hi Anthony - I need to group the hours fortnightly (currently shown as daily):

     

    This is so I can compare it with the fortnightly budget already calculated in a new column (different table):