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.
Could you pls share your pbix and result you want to display ?I need data to test .Remember to remove confident data.
Best Regards
Lucien
@SvenJacobs
Please try:
FlatsBezetPerDatum =
VAR __startdate =
FIRSTDATE ( DateTable[Date] )
VAR __enddate =
LASTDATE ( DateTable[Date] )
RETURN
CALCULATE (
COUNT ( 'Bewoners_Contracten (Sharepoint)'[ContractId] ),
FILTER (
'Bewoners_Contracten (Sharepoint)',
'Bewoners_Contracten (Sharepoint)'[DatumInHuizing] >= __startdate
&& ( 'Bewoners_Contracten (Sharepoint)'[DatumuithuizingZonderNull] <= __enddate )
),
'Bewoners_Contracten (Sharepoint)'[DatumInHuizing] <> BLANK()
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
The 2 DAX codes seem to work only I guess my thinking is not correct..... Why because if I have 100 flats i can not. Need to figure out how your HR thing worked. Because I want to know on a specific date in time the amount of flats that wher rented out.
@SvenJacobs Are you trying to find active between the start and end date. Refer to this example
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |