Forum Discussion

sagivh's avatar
sagivh
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Card with only last day data

Hello, I have a trend that shows daily active users and I want to have a card showing only the last day of that trend, it seems the card has a filter by date but i need to pick a date and cannot set ...
Need Help
  • VijayP's avatar
    VijayP
    6 years ago

    Based on the filter context it takes last of that period and if no filter then it takes the latest date.

    And its dynamic based on incremental data

VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
6 years ago

sagivh 

Try using  = LASTDAY(date column in your data).

Please let me if this is a solution for your question and please mention this as solution and give your Kudos

Regards

Vijay Perepa

Watch my Power BI Tutorial Videos at  Vijay Perepa-A MEET Z Tech