cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
suhaimisuib
Regular Visitor

Need help on active courses

Hi all i quite new to POWERBI  

 

Need help on the measure to filter table list the course that only active within the start and end date. 

 

Course NameSt.DateEn. Date
A17 April 202119 April 2021
B22 April 202125 April 2021
C21 April 202123 April 2021

 

My source file is from excel actually i have try setting a cell G1 with formula =TODAY() 

and have a column Active Status  =AND($G$1>=[@[St.Date]],$G$1<=[@[En.Date]])

which will return either TRUE and FALSE. And then I visual the table in powerbi and use filter visual option and select TRUE only 

 

But the problem is the visual is not dynamic with the date today, I have to open the excel workbook then only the data updated. 

I need help how to get straight away in powerbi data model since i cant edit model in powerbi desktop im using live connection sharepoint sharing file. 

 

any measure dax with summarize table could help me on this?

 

Appreciate assistance thank you. 

1 ACCEPTED SOLUTION
Jihwan_Kim
Community Champion
Community Champion

Hi, @suhaimisuib 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

All measures are in the sample pbix file.

 

Picture5.png

 

https://www.dropbox.com/s/xgsthg46i70huqk/suhaimishib.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: https://www.linkedin.com/in/jihwankim1975/

View solution in original post

3 REPLIES 3
Jihwan_Kim
Community Champion
Community Champion

Hi, @suhaimisuib 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

All measures are in the sample pbix file.

 

Picture5.png

 

https://www.dropbox.com/s/xgsthg46i70huqk/suhaimishib.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: https://www.linkedin.com/in/jihwankim1975/

View solution in original post

Hi @Jihwan_Kim  thank you very much it is actually half way solve my problem how if i want to change it to table list instead using card ? I just removed

CONCATENATEX function will do right?

Hi, @suhaimisuib 

Thank you for your feedback.

I am not sure, but I do not think it will work.

 

Please check the below link, whether it is what you are looking for.

 

Picture7.png

 

https://www.dropbox.com/s/xgsthg46i70huqk/suhaimishib.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: https://www.linkedin.com/in/jihwankim1975/

 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors