cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

Previous Month is Blank in Card Visual but not in Table

Hello

Please can someone help me understand why I am having this issue and how to resolve it. If i use this formula CALCULATE([Properties],PREVIOUSMONTH('Calendar Table'[Date])) I get this as seen in the screen shot below:

When I try this formula CALCULATE([Properties],PREVIOUSMONTH(LASTDATE('Fact Table 1'[Property CreateDate]))), I get this as seen in the screen shot below

I want the system to calculate the total records for previous month. Your help is most appreciated.

Even this formar

Previous Month = CALCULATE([Properties],DATEADD('Calendar Table'[Date],-1,MONTH)), gives me the screen shot below, which is inacurate, because the 8,712 should not have been included in the previous month reported value

4 REPLIES 4
Super User

it looks like that your second try returns the correct value.

what's the expected output?

it returns blank is because you don't give the specific month for the card visual, so can't return the last month's value.

it works in the table because for each row there is a month slicer.

Proud to be a Super User!

Resolver I

well the expected output should not include the 8712. It should return the sum without 8,712

Super User

what about you sum all the amount and minus the latest month?

pls provide some sample data (not the table visual or the screenshot).

Proud to be a Super User!

Resolver I

Hello Ryan

I used the queries for the start and end date:

Start date = #"Date.StartOfYear"(List.Min(Properties[Property CreateDate]))

End Date =#"Date.EndOfYear"(List.Max(Properties[Property CreateDate]))

Used the start and end date to create a table using this query:  = {Number.From(#"StartDate")..Number.From(#"EndDate")}

Followed these steps to create the calenda table

I would expect the previous month total to exclude Property ID = C30, the total of previous month will be 29.

Thanks in advance and for looking into this.

Some columns from my calendar table.

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors