Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
smina
Frequent Visitor

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 2
smina
Frequent Visitor

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

smina_0-1692053196201.png

 

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

smina_1-1692053467833.png

 

 

AnthonyGenovese
Resolver III
Resolver III

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!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.