Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Experts, Kindly need your help on all new request. Let me take bit of time to explain the scenarion step by step for your easy understanding.
1. We have a portal and report to show how many users are visited the pages
2. Below example - start date of the portal visits is on 12th June and this is the base for the week (around 1250 unique visited users)
3. 13th June few users visisted the page and need to check the repeated users from 12th June
4. on 14th June again few users visited the page but this time my base should be 12th June (+ plus) 13th June New users and need to check repeated users
5. Now, on 15th June again few users visited but this time my base should be 12th June (+Plus) 13th June New users (+Plus) 14th June new users and check for repeated users.
Kind Note: #N/A Refers for New users in the screenshot.
Hope you are getting the requirement now.(below screenshot for your reference)
Now, #N/A should gets added on every day to my base which is 12th June and daily need to check the repeat users
Also, which ever we found users while vlookup it should add and show the value in Chart (as a repeated users) . Kindly help me if we can create some views and share PowerBI sample file. I am available on phone (+91 - 7829523444) for any queries. and looking for quick resolutions as a business requirement.
@selimovd @v-lili6-msft @v-xiaoyan-msft @amitchandak @mussaenda @v-easonf-msft
Solved! Go to Solution.
Hi @Prabhakaran_Nag ,
According to your description, I create a sample:
Table:
Table2:
Table3:
Here's my solution, create a calculated column in Table2:
Column =
IF (
LOOKUPVALUE ( 'Table'[ID_12th], 'Table'[ID_12th], 'Table2'[ID_13th] ) = BLANK (),
"N/A",
[ID_13th]
)
Create a calculated column in Table3:
Column =
IF (
LOOKUPVALUE ( 'Table'[ID_12th], 'Table'[ID_12th], 'Table3'[ID_14th] ) = BLANK (),
IF (
LOOKUPVALUE ( 'Table2'[ID_13th], 'Table2'[ID_13th], 'Table3'[ID_14th] )
= BLANK (),
"N/A",
[ID_14th]
),
[ID_14th]
)
Get the correct result:
I attach my sample below for your reference.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Prabhakaran_Nag ,
According to your description, I create a sample:
Table:
Table2:
Table3:
Here's my solution, create a calculated column in Table2:
Column =
IF (
LOOKUPVALUE ( 'Table'[ID_12th], 'Table'[ID_12th], 'Table2'[ID_13th] ) = BLANK (),
"N/A",
[ID_13th]
)
Create a calculated column in Table3:
Column =
IF (
LOOKUPVALUE ( 'Table'[ID_12th], 'Table'[ID_12th], 'Table3'[ID_14th] ) = BLANK (),
IF (
LOOKUPVALUE ( 'Table2'[ID_13th], 'Table2'[ID_13th], 'Table3'[ID_14th] )
= BLANK (),
"N/A",
[ID_14th]
),
[ID_14th]
)
Get the correct result:
I attach my sample below for your reference.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |