Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
@ignaciokairuz , You need created date column without time for these three column
example
DAX
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))
Power Query
DateTime.Date([datetime])
You need to join them with a common date column and two joins will be inactive, which you can activate using userelationship in measure
@ignaciokairuz , You need created date column without time for these three column
example
DAX
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))
Power Query
DateTime.Date([datetime])
You need to join them with a common date column and two joins will be inactive, which you can activate using userelationship in measure
EDIT : Now I managed to understand! To those who , like me , can take a while to understand it, this is my way to paraphrase the solution :
Create a separate table with all the dates used in the principal table. Create a relationship using using Power BI / Power Query / Power Pivot ( I used Power Pivot ) between each of the 3 columns and the separate date table (2 of those columns should be inactive by deselecting the checkbox at the bottom left side of the dialogue box when creating said relationship). Then create a measure using this formula
=DIVIDE(CALCULATE(COUNT(Tabla4_2[deleted]);USERELATIONSHIP(Tabla4_2[deleted];Tabla3[dates]));[Recuento de created])
Hope it's easy to understand!
Have a nice one!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |