Forum Discussion
Searching data in common from two list
Hi everyone, I have a question. I have this fact Table that is about memberships from a gym. Customer Start Date End Date 1 01/03/2023 28/02/2024 2 01/04/2023 31/03/2024 3 01/05...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhzRl8052qJ9QGeVp?e=Vhf0Px
Hi Ahmedx , look what I receive.
This is the measure with the changes:
Active Members History =
VAR _Date =
VALUES ( dimDates[Date] )
VAR _tbl1 =
SELECTCOLUMNS (
GENERATE (
'factCustomerHistoryHistory',
DATESBETWEEN ( 'dimDates'[Date], 'factCustomerHistoryHistory'[Start_Date], 'factCustomerHistoryHistory'[End_Date] )
),
"@Customer", [Customer ID],
"@Date", [Date]
)
VAR _tbl2 =
GENERATE ( VALUES ( 'factCustomerHistoryHistory'[Customer] ), _Date )
RETURN
CALCULATE ( DISTINCTCOUNT ( 'factCustomerHistoryHistory'[Customer] ), INTERSECT ( _tbl2, _tbl1 ) )
What do you think it is?
Ahmedx
Super User
Super Userit says that it is not possible to align text with a number. I don't know the reasons for this, you could not give a link to your file to see